data type varchar to data type money

M

MichaelCree

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
 
Top