troubling quotes

Klaas · Apr 9, 2006

On my Access form, I try to copy the value of number field TitleID to a
text field NewTitleID while adding a character to the number. For instance,
number 435 should change to A435. I have tried things like
"Me.[TitleID] = '" """A""" & Me![NewTitleID] & "'"

Nothing works. What can I do? Your help is appreciated greatly.

Klaas

Douglas J. Steele · Apr 9, 2006

Me!TitleID= "A" & Me!NewTitleID

Klaas · Apr 10, 2006

Douglas J. Steele wrote in microsoft.public.access.forms:

Me!TitleID= "A" & Me!NewTitleID

....and it works like a charm!

Thank you very much.

Klaas