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

On the form where you are updating the data, you need two fields. One to hold the numeric portion and a separate one for the suffix. You cannot store a suffix in a numeric field. When you are displaying the data in a report you can concatinate the two fields so they look nicer.

=fld1 & fld2