If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
displaying units in access number field
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? |
#3
|
|||
|
|||
displaying units in access number field
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 |
Thread Tools | |
Display Modes | |
|
|