Memo field

[Dave Eyley]

Hi All,

I am trying to use a memo field to record a list of names. I don't want to use another table.
The form I am using can send emails to people selected by the user. The form then finds the valid email address and sends the email recording the addressee to the memo field list.
The problem is I can't seem to find a way of reliably adding the names so they look like a list.
I've tried -

Me!MemoField=Me!MemoField & Chr$(10) & NewName

and

Me!MemoField=Me!MemoField & Chr$(10) & Chr$(13) & NewName

and

Me!MemoField=Me!memoField & Chr$(10) & Chr$(10) & NewName

with varying degress of reliability but none giving a predictable clean list of names.

Any ideas?

Dave Eyley

 

[ColinEssex]

A Memo field is like an extremely large text box. It will be very difficult to select names from it (like you would do in a ListBox).

Presumably the names are in a table already? why would you need another table?

Col

 

[Dave Eyley]

Hi Col,

The memo field is part of a table for records relating to reports. The memo field stores a list of names that have been sent the report.

It seemed a logical place to store the list.

Dave

 

[ColinEssex]

Ah, so you're not wanting to actually select from the list then.

Col

 

[Dave Eyley]

No. The field is not one that is used for anything other than recording who's been emailed.

The problem I have is similar to when I use Chr$(10) in MsgBox statements like -

MsgBox "You are about to delete this record" & Chr$(10) & "Are you sure?",vbexclamation

Putting one Chr$(10) has no effect but putting 2 puts 2 blank lines in. I've tried different combinations of Chr$(10) and Chr$(13) to no avail...

I dare say I'll find another way to do it but I don't like giving up that easy...

Thanks

Dave

 

[GaryPanic]

are you charatcers correct - should it not be & Chr(13) & Chr(10) ???

 

[ColinEssex]

Gary beat me to it

Try carriage return then the line feed

Col

 

[GaryPanic]

Its cos, I was doing this last night ....(other than that I would of kept quite...)

g

 

[Dave Eyley]

Thanks Col/Gary,

It was my error of using Chr$(10) instead of Chr(10).
I have tried Chr(13) & Chr(10) and it works fine.

Thanks for your help

Dave

 

[Dave Eyley]

Thanks Col/Gary,

It was my error of using Chr$(10) instead of Chr(10).
I have tried Chr(13) & Chr(10) and it works fine.

Thanks for your help

Dave