M mcgooie Registered User. Local time Today, 07:06 Joined Sep 12, 2006 Messages 11 Jan 26, 2007 #1 Does anyone know if its possible to change the data type of a field from "Text" to "Number" by using a macro? thx
Does anyone know if its possible to change the data type of a field from "Text" to "Number" by using a macro? thx
neileg AWF VIP Local time Today, 07:06 Joined Dec 4, 2002 Messages 5,970 Jan 26, 2007 #2 Why? You can change it in a query using CDbl(), Val() or similar in a calculated field. Bear in mind that if your data is not capable of of being converted, you'll get errors.
Why? You can change it in a query using CDbl(), Val() or similar in a calculated field. Bear in mind that if your data is not capable of of being converted, you'll get errors.
