I'm trying to use access to create individual client letters, where I can enter all the discrete data into my form, and then have a customized letter with that client's info. I assume this would be a type of report, right?
Also...I need to be able to cut and paste from the individualized letter into another application (i.e. email)
I'm a bit of a newbie, so forgive me, but here are my problems:
- I can't figure out how to create a form/report where you have data cells inside a separate text box
- When I almost get this to work, I can't copy and paste the entire text
getting close! that's helpful. now my problem is that Access doesn't realize my fields are text strings (even though they are labeled that way) so it won't let me insert them into another text string.
excel has a formula TEXT([field]) that labels the field, can't find that in Access..