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
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