<div>
<div class="content wysiwyg-content">
I have a field on a sub-form that is short text because sometimes &quot;ADVISE&quot; may be entered in the field. &nbsp;But other times number are entered. &nbsp;When numbers are entered I want the value to look like 34.12 for example. &nbsp;But if 34.1 is entered it ends up looking like 34.1 instead of 34.10.<br />
<br />
How can I make it look like 34.10 ?
</div>
</div>


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 ?

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.