Kameron

[Kam]

Hi - I want to run an update a memo field using an update query. not sure
why it will not let me update the field when there is more than 127
characters. it comes up with the error message invalid argument. can anyone
provide some guidance. i kinda wanted to avoid using VBA, but if thats the
only solutions...so be it.

thanks in advance.

Kam

 

[John Vinson]

Hi - I want to run an update a memo field using an update query. not sure
why it will not let me update the field when there is more than 127
characters. it comes up with the error message invalid argument. can anyone
provide some guidance. i kinda wanted to avoid using VBA, but if thats the
only solutions...so be it.

thanks in advance.

Kam

Please post the SQL of your query.

It's also considered polite to post a short but descriptive subject of
your problem in the Subject line, rather than your name.

John W. Vinson[MVP]