Suffixes in number fields

Robert C

Registered User.
Local time
Today, 22:11
Joined
Mar 27, 2000
Messages
88
I have a series of fields on a form into which I enter dimensions, weights or volumes. I would like to be able to automatically follow the figures I enter with the relevant suffix, i.e. "mm", "kg" or "lt". However I want them to retain their status as numbers so that I can perform calculations on them. The input mask wizard does not work on number fields. I realise I could simply put a label after the text box but I would like something a bit more sophisticated than this if possible.

I would also like to be able to represent these suffixes in reports as well so that they remain number fields but appear as, for example, 2,400mm.

Any help would be gratefully received.

Thanks
 

Users who are viewing this thread

Back
Top Bottom