| | |
|
|
|
displaying units in access number field |
|---|
| message from =?Utf-8?B?Z2FsbmV3ZWluaGF3?= on 4 Jun 2004 |
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?
|
| Steve Schapel replied to =?Utf-8?B?Z2FsbmV3ZWluaGF3?= on 05 Jun 2004 |
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.
|
| John Vinson replied to =?Utf-8?B?Z2FsbmV3ZWluaGF3?= on 04 Jun 2004 |
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
|
|
Archived message: displaying units in access number field (MS Access Database)
