Tesiny, Ed
EdTesiny at oasas.state.ny.us
Wed Dec 1 08:26:58 CST 2004
Have you tried the CLng() function? Ed Tesiny EdTesiny at oasas.state.ny.us -----Original Message----- From: Joe Hecht [mailto:jmhla at earthlink.net] Sent: Tuesday, November 30, 2004 9:09 PM To: 'Access Developers discussion and problem solving'; 'ACCESS-L' Subject: [AccessD] Convert text to number X posted Finally found big trap in inherited database. Foreign Key Vendor ID is set as text. I need to convert it to long number. If I change data type to number Access threatens to delete all fields. I cannot find anything in help on Cnum. All thoughts apreciated JOE HECHT LOS ANGELES CA jmhla at earthlink.net -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com