Data unrecognizable - WHY?

[MelissaBerrett]

I have a table with a check number in it. Because of the program I am using to pull the data from a DOS system into the MSDB, the check number has to be text. When I pull the data into the table, and someone searches for a check, it can't be found. So I go into the backend table, save the table with the checknumber as numberic, and then again as text, and then the check number can be found. Why do I have to do this? Is there a way to prevent this?
Thanks!!!

 

[SgtJarrow]

IN the search setup, you can convert the "text" check number to a number by using:

CDbl([checknumber])

or the number searched for to text by:

CStr([searchnumber])

The problme you are having is you are searching a string value with a number entry and vice versa, and these will not match. Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com