Michaelcree
Instructor
Hi All
I have a access form which has a field which needs to be a currency. The text field on the form is set to be a Currency. The table (Which is on an SQL 2000 Server)also has its properties set to be a currency (Data Type - Money Length - 8)
But when I try to enter an amount on the field I get the following message
"Disallowed implicit conversion from data type varchar to data type money" and that I should use the CONVERT function
Any Ideas
I have a access form which has a field which needs to be a currency. The text field on the form is set to be a Currency. The table (Which is on an SQL 2000 Server)also has its properties set to be a currency (Data Type - Money Length - 8)
But when I try to enter an amount on the field I get the following message
"Disallowed implicit conversion from data type varchar to data type money" and that I should use the CONVERT function
Any Ideas
