Hello all!
I'm a very basic Access user and I could use your help.
For the report I'm trying to create, I'd like to format the design of the text so that it dynamically positions based on the length of a previous and separate field.
For example, at the head of each page, I'd like a sentence as such:
Summary Report generated for [XYZ Company] for the month of [Current Month]
When creating the report, I'd like it to appear as a nice, continuously spaced sentence. However, the company name field [XYZ Company] could be from ~10 to up to 50 characters.
Is there a way to bind the rest of the phrase so that it auto-adjusts its position to the length of the [XYZ Company] field and automatically position itself to appear to be coherent sentence?
Thank you very much!