trouble concatenating text of 1 memo field to another memo field in same record via button

G

ghadley_00

I have an access database form where I have a button that is supposed
to be appending the contents of 1 memo field to another is behaving
non-predictably. The code is:

Me![ToDo] = Me![ToDo] & Chr$(13) & Chr$(10) & Me![Studies1] &
Chr$(13) & Chr$(10) & Me![Studies2]
Me![Meds] = Me![MedsEntered] & Chr$(13) & Chr$(10) & Me![IVF] &
Chr$(13) & Chr$(10) & Me![Diet]
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70

Any thoughts on what I'm doing wrong? Could there be a casting problem?
(I just want to append the text of 1 field to another field - am I
actually assigning objects this way?)

Any help would be greatly appreciated.

GH
(e-mail address removed)
 
D

Douglas J Steele

What problem are you having? Your code looks reasonable (although you could
use vbCrLf rather than Chr$(13) & Chr$(10), and you could save the record
using Me.Dirty = False)
 

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

Top