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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Choose between Currency and Euro? 5
Cell not calculating after importing data 2
Converting varchar to numeric 4
Currency designations 2
Problem with form--subform 5
How do I clear a form? 0
mail merge Word 2003 - Excel 2003 data source. 1

Top