Controlling Input TeeSee <bkeanie[ at ]glasscellisofab.com> 12/15/2008 11:35:23 PM Win XP and Access 2003 Currently asking user to input a % into a textBox as .25 for example. How can I code a check that it is input as .25 and not 25? I think I have to convert the input to a string in order to test it but can't figure out how to do that. I have searched this "group" for solution but cannot come up with one. Any guidance would be appreciated. Thanks as usual.

Re: Controlling Input Marshall Barton <marshbarton[ at ]wowway.com> 12/16/2008 12:30:04 AM TeeSee wrote: [Quoted Text] >Win XP and Access 2003 >Currently asking user to input a % into a textBox as .25 for example. >How can I code a check that it is input as .25 and not 25? >I think I have to convert the input to a string in order to test it >but can't figure out how to do that. I have searched this "group" for >solution but cannot come up with one. Any guidance would be >appreciated. Maybe you can use something like this in the text box's AfterUpdate event: If Me.textbox > 1 Then Me.textbox = Me.textbox / 100 -- Marsh MVP [MS Access]