Kim has attended:
Excel VBA Intro Intermediate course
Access
Hi,
I have a text field I need to update with a new note on a few hundred clients; some of the records already have text that I don't want to be over-written.
Is there a way to add text to the begining of the field where it is not null.
Thanks
RE: Access
Hello Kim,
The method of achieving this can vary depending on the context in which and how the new text is applied, also what code you currently use to populate.
Maybe you could concatenate the additional text such as:
Forms!Form3!Text5 = Forms!Form3!Text5 & strResult
I hope this gives you an idea as to how to approach this.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer