Full Version: Combine Label and Text Box
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
ToyotaSupra88
I wanted to know is it possible to insert a TEXT BOX into a LABEL... For example, I'm creating this report that has this statment:

"This Letter will serve as a follow-up to Company Name letter of February 21, 2005 , and as a notice of cancellation."

The bold text is the TEXT BOX and everything else in the quotes is related to the LABEL.
ChrisSymonds
Hi,

This is similar to a problem I had, so you might find this thread helpful, see last answer in particular.

Regards,

Chris
ToyotaSupra88
Oh I should have known it was that easy.... thanks.

CODE
  
="This letter will serve as a follow-up to the first letter dated " & [senddate02] & " testing concatenate."


But now I just need the date field to in bold and display in this format "mmmm dd, yyyy" and not in this one "mm/dd/yy" - I might have to set up the format in the table or the query.

Question:
Does the unbound text box have a limit to the number of how many characters that can be used? For example is the max 255 ??? Or could I type up a whole letter in one box?
ToyotaSupra88
Hey Chris,

I was wondering, if I can't get this to work in MS Access - Maybe I could MailMerge the data into MS Word BUT is it possible to GROUP items together in a MailMerge?

Thanks for your help.
-Gil
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.