How to append text to a text box?

[pokdbz]

I have a list if medications and I need to know how to append them to a text
box so it comes out like this:
Med1, Med2, Med3, Med4

I have a bunch of checks to see which medications they are on but want to
list them in a text box. How do I get them to append to the text box?

 

[Douglas J Steele]

Is this for display purposes only, or do you want to store the values that
way?

Storing multiple values in a single field is actually a violation of
database normalization rules: each field must represent a single thing.
What's typically done is to have a second table, related to the first in a
many-to-one relationship.

For display purposes, take a look at
http://www.mvps.org/access/modules/mdl0008.htm or
http://www.mvps.org/access/modules/mdl0004.htm at "The Access Web".

 

[pokdbz]

This is just for display purposes

Is this for display purposes only, or do you want to store the values that
way?

Storing multiple values in a single field is actually a violation of
database normalization rules: each field must represent a single thing.
What's typically done is to have a second table, related to the first in a
many-to-one relationship.

For display purposes, take a look at
http://www.mvps.org/access/modules/mdl0008.htm or
http://www.mvps.org/access/modules/mdl0004.htm at "The Access Web".