How can I handle a variable length account name and open date placement in a report....

[Pack10]

I have a form letter that goes out to a customer (Business Account). The account name can be quite long, we also show the account open date on that line on the report. Problem is, it looks bad because if the account name is for instance 30 characters, the account open date appears too far to the right on the letter and it looks lousy.
Is there a way I can program for this or better use one of the properties.


XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99/99/9999
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 99/99/9999

 

[dhookom]

Are you using one text box or two?
What do you want to happen if the account name is too long?

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

There are two text boxes. If the field is too long, they will do it manually outside of the database so
that is not an issue.

 

[dhookom]

So, is there still a question or issue? If so, I don't understand what kind of answer you are looking for.

Duane
Hook'D on Access
MS Access MVP