displaying units in access number field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 fiel

Can anyone help me?
 
Galneweinhaw,

It would be best to store the Units in a separate field. This means
adding a Units field to the table. On the form, you can arrange the
controls for the number field and the units field so they almost appear
to be one, but the users of the form will have to get used to entering
the quanitiy and units separately. Still, that is preferable to using a
single text field for both pieces of information, which then makes
retrieving the numerical quantity difficult if you want to do calculations.
 
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?
Click to expand...

If all records have the same unit for a given field (i.e. you don't
have values in mm in some records, cm in others, and inches in yet
others), you can simply display the units without storing them in the
table; set the Format property of the field to (e.g.)

"# mm"
 
Back
Top