>>>I have a textbox where I want the default type to be numeric. I know I can put a 0 in the value property of the textbox, but I don't want the zero to be displayed in the textbox initially. Is there another way to make the textbox numeric? or is there a way to not show the zero initially?
>>>
>>>Thanks,
>>>
>>>Paul
>>
>>I have an app running now for a user that absolutely insisted all fields be blanked initially including numerics. This is what made her happiest:
>>
>>ControlSource lcPayCode
>>InputMask 999999999
>>Value (None)
>>
>>In the Valid Method:
>>
>>lnPayCode = VAL(ALLTRIM(THIS.VALUE))
>>
>>It is a PITA to change formats back and forth but I have a happy user.
>>
>>HTH
>
>Would Text.Format="Z" do the same?
Good Morning Ed,
Yes and no. The difference is with Text.Format="Z" the control shows 0 when it has focus. I thought that was a good thing. My user disagreed so I found a way to give her exactly what she wanted.
Bob Kocher
www.swfox.netStart making your plans now to attend Southwest Fox 2006