>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