<div>
Hi,<br />
<br />
You could use the Trim function to eliminate the space<br />
<br />
Regards
</div>


Hi,

You could use the Trim function to eliminate the space

Regards

<div>
Thanks. I did not even try, because I read <a href="http://office.microsoft.com/en-za/access-help/input-mask-syntax-and-examples-HP005187550.aspx" rel="ugc">http://office.microsoft.com/en-za/access-help/input-mask-syntax-and-examples-HP005187550.aspx</a><br />
It says there<br />
9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Digit or space (entry not required; plus and minus signs not allowed).<br />
So I did not want to allow a space.
</div>


Thanks. I did not even try, because I read http://office.microsoft.com/en-za/access-help/input-mask-syntax-and-examples-HP005187550.aspx [http://office.microsoft.com/en-za/access-help/input-mask-syntax-and-examples-HP005187550.aspx]
It says there
9      Digit or space (entry not required; plus and minus signs not allowed).
So I did not want to allow a space.

<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I have a textbox on a form where I only want to allow either four or five digits with no spaces.<br />
Mask &nbsp; &nbsp; 00009 &nbsp; &nbsp; requires at least that the first four entries are digits and the fifth one can either be a digit OR A SPACE. <br />
How can I prevent users from adding a space at the end of the four digits? There must either be a digit or nothing.<br />
Unfortunately the field format is text and can for reference reasons not be changed.
</div>
</div>


I have a textbox on a form where I only want to allow either four or five digits with no spaces.
Mask     00009     requires at least that the first four entries are digits and the fifth one can either be a digit OR A SPACE. 
How can I prevent users from adding a space at the end of the four digits? There must either be a digit or nothing.
Unfortunately the field format is text and can for reference reasons not be changed.

Input Mask in Access textbox. Allow only digits, no spaces.

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.