>Hi Tom,
>Thanks for your prompt reply. The reason for me adding the '***'
>in my title is for easy recognation which are my posted topics.
>As everyday I am receiving many emails. Sorry for the distraction.
>
>Besides the Input Mask/Format properties, is there any way to
>declare the textbox types? As for the Input Mask, the user need
>to follow the exact format as specified. Please advise.
>
>
>>
>>>How could I declare a text box type to be character/numeric field.
>>>So that while appending record into a Table, there would not
>>>be any "Type Mismatch" error occur.
>>
>>Look at the Input Mask & Format properties in the Data tab.
>>
>>BTW, no need to add '***' in your titles -- we all get the stuff answered
>>pretty quick & most questions (if not all) get answered. And you will
>>usually get more then one reply.
>>
>>HTH,
>>Tom
>>
>>
You also have formats in the DBC and a message you can add for bad entries. You don't have to be exact -- check out the formats, etc. Off hand I cannot think of anything else much better.
Tom