Format a text box on a data access page

[tdin]

I am starting to use data access pages from Access 2000. I am able to create the pages rather easily, but would like to be able to set formats and input masks as I can on forms. I can still put the input mask or format on the table but I does not work for the data access page. Is there a way to accomplish this. For example, I want phone number to show up as (999)999-9999 instead of 9999999999.<br>
<br>
Thanks in advance.

 

[rhicks]

Set the Input Mask property in your forms for the text boxes to:<br>
<br>
!\(999&quot &quot;000\-0000;;_ (Phone Number)<br>
<br>
You will then see the numbers formated the way you wish.<br>
<br>
HTH<br>
RDH

 

[boxman1]

tdin,
working on same issue. noticed the reply only addressed forms; were you able to get the page textbox to display properly? if so please share the wealth of your knowledge.

thank you,