<div>
Thanks, what I was really looking for was a control &nbsp;rather than having to put this code in every text box. However I suppose I could create a user-control.<br />
<br />
Mike<br />

</div>


Thanks, what I was really looking for was a control  rather than having to put this code in every text box. However I suppose I could create a user-control.

Mike


<div>
<div class="content wysiwyg-content">
I need a data-bound text box that shows DAO data from the JET engine formatted as required i.e format(foo,&quot;###0.00&quot;).<br />
I have tried to set the Access format value when designing the database but the values come back raw. The Masked Text control NEARLY works but is left formatted, I also need the ability to have the control locked when required.
</div>
</div>


I need a data-bound text box that shows DAO data from the JET engine formatted as required i.e format(foo,"###0.00").
I have tried to set the Access format value when designing the database but the values come back raw. The Masked Text control NEARLY works but is left formatted, I also need the ability to have the control locked when required.

A formatted text box

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.