adding units to number fields in Access

[galneweinhaw]

I want to add units to my Access forms that use numbers. I found how to add % sign but I can't figure out how to add mm or deg F or any other kind of units to my numbers without changing it to a text field

Can anyone help me?

Thanks

[hspc]

try to make a query that formats the field
something like this :
Select cstr(MyNumber) +'F' from Table1