Data type mismatch in criteria expression.

Tech-Archive recommends: Speed Up your PC by fixing your registry

Update tblTour SET TourName = 'Honduras',TourLength = '10
Days',TourDescription = 'We will be chartering a live aboard boat with
12 fellow divers off the coast of Hunduras. We can expect to see sever
different marine life as we will be making 5 dives per day and one at
night. There will be several sunken reefs for us to checkout as well.
There is an on board cook and house keeper. There will be a dive
briefing before all dives. This Tour is reserved for experienced divers
only.',TourLocation = 'Hunduras',TourPrice = '2999',TourPic =
'../pics/sunkenreef.jpg' WHERE TourID_pk = '1';

Thats the SQL statement.

Here are the datatypes:

TourName: text 50
TourLength: text 50
TourDescription: Memo
TourLocation: text 50
TourPrice: Currency
TourPic: text 50

I get the error:
Data type mismatch in criteria expression.

These are all valid entrys manually, but for some reason I can't get it
to work with an update query.

Any help is much appreciated.

.