<div>
Hi se2welch,<br />
<br />
Use an input mask &quot;0.00&quot;<br />
<br />
<br />
Good Luck!<br />
<br />
Gary
</div>


Hi se2welch,

Use an input mask "0.00"


Good Luck!

Gary

<div>
<br />
Hi Gary,<br />
<br />
Thanks for the post, however an input mask will only work when the field is a text field and requires the same leading zero as my solution of changing the field to be a text field and using the (&quot;Like &quot;#.##&quot;) validation. &nbsp;I was hoping there might be a way to do it and leave it as a number field.
</div>



Hi Gary,

Thanks for the post, however an input mask will only work when the field is a text field and requires the same leading zero as my solution of changing the field to be a text field and using the ("Like "#.##") validation.  I was hoping there might be a way to do it and leave it as a number field.

<div>
<br />
Ahh. &nbsp;It's just the imput mask wizard that only works for text and date! &nbsp;Thanks so much!
</div>



Ahh.  It's just the imput mask wizard that only works for text and date!  Thanks so much!

<div>
<div class="content wysiwyg-content">
<br />
Hi.<br />
<br />
I'm trying to get a field in Access to only accept entry of 2 decimal places (eg 1.85) and to reject a user attempt to enter 1.851 or 1.8.<br />
<br />
I've tried using setting the field to be a number and using a validation rule (Like &quot;#.##&quot;), and this works to a certain extent, but also rejects numbers with a trailing zero such as 1.80.<br />
<br />
Changing the field to be a text field and using the (&quot;Like &quot;#.##&quot;) validation works, but it forces the user to enter any leading zeros (eg. 0.80) which isn't ideal.<br />
<br />
Any ideas?<br />
&nbsp;
</div>
</div>



Hi.

I'm trying to get a field in Access to only accept entry of 2 decimal places (eg 1.85) and to reject a user attempt to enter 1.851 or 1.8.

I've tried using setting the field to be a number and using a validation rule (Like "#.##"), and this works to a certain extent, but also rejects numbers with a trailing zero such as 1.80.

Changing the field to be a text field and using the ("Like "#.##") validation works, but it forces the user to enter any leading zeros (eg. 0.80) which isn't ideal.

Any ideas?
 

Validation rule needed to force 2 decimal place entry in Access 2003

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.