displaying units in access number field

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?

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.

--
Steve Schapel, Microsoft Access MVP


galneweinhaw wrote:
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?

On Fri, 4 Jun 2004 11:26:03 -0700, galneweinhaw
wrote:

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?

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"


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public