Avatar of SteveL13
Flag for United States of America

asked on 

How format text field on a form to look like numbers with 2 decimals if numbers are in the field

I have a field on a sub-form that is short text because sometimes "ADVISE" may be entered in the field.  But other times number are entered.  When numbers are entered I want the value to look like 34.12 for example.  But if 34.1 is entered it ends up looking like 34.1 instead of 34.10.

How can I make it look like 34.10 ?
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon