I have watched but not yet learned and digested the whole of this seminar and have nothing bur praise for it and its presentation.  Well done, Rick.
Can you help on one small point woncerning string concatenation, please.
Is there a code or character or other means to force a Line Feed and Carriage Return within a concatenation?
I have a database containing the following fields,
Address1, Address2, Address3, Town, County, PCode, and would like to amalgamate all those three into one field called Address but with each original field on a new line.  Can that be done?
Many thanks,
David

---

Reply from Richard Rost:

Sure. You can say:

FullAddress: [Address1] & Chr(13) & Chr(10) & [Address2] & Chr(13) & Chr(10) & [Address3]

That will insert CARRIAGE RETURN and LINE FEED characters between your fields, giving you the desired effect.

Keep in mind, however, that I strongly recommend you leave all 3 address fields SEPARATE in your table, and just assemble them as needed in a query.