Dynamic Text Positioning in Report Based on Separate Field Length

[Enrightt]

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!

[pbaldy]

A textbox control source like:

="Summary Report generated for " & [CompanyField] & "for the month of " & [MonthField]

[pbaldy]

Oh, and if you meant the current month not coming from the data, you can use any of the various date functions, like

Format(Date(), "mmm")

[Enrightt]

Oh, and if you meant the current month not coming from the data, you can use any of the various date functions, like

Format(Date(), "mmm")

Thank you very much!

[pbaldy]

Happy to help!