CODEWITHSUNDEEP
formsms-accessformat
Geoff
Geoff

Reputation: 5

Microsoft Access field formatting - adding unit type

I'm trying to display the unit type to some numeric fields in an access database.

So for instance a value of '15' in FieldA will display as '15 inch', and '26' in FieldB will be '26 mm'. Is this possible with field formatting?

Upvotes: 0

Views: 1692

Answers (1)

AVG
AVG

Reputation: 1462

Have you tried it? As long as your field is a some type of number field, it should work fine. Just set the format to #" inch" or #" mm".

Upvotes: 1

Related Questions