Address Display Tips 1

[Najemikon]

Hi,

I have a database which is used for printing invoices & there's one point I'm finding really annoying.

I have a table setup for customer addresses, with a variety of typical fields (address line 1, line 2, line 3, etc). Not all of them are used every time. For instance, line 2 is for department, but that's often not filled in.

Basically, there are holes in my data! I hate it when I print out the report; the address can be quite fragmented, simply because a minority of records need the extra data. Is there anyway to make the report ignore empty fields & print the address neatly?

I did think of doing it via an unbound text box, which I have used in the past to build sentences out of seperate fields, eg "Hello [User] you last logged in [date] at [time]" on a menu form.

I can't think how to build this into a nice neat block though, rather than a sentence, simply because I can't get my head round the carriage returns! Anyone got any ideas?

 

[GShen]

Are you printing left to right seperated by commas or are you printing down?
And is the and MDB or ADP database?

 

[Najemikon]

It's an MDB database & the address needs to be printed downwards. In fact, standard formatting so that the invoice, when folded will fit in a windowed envelope, eg:

Contact
Job Title
Company Name
Building no. & street name
Industrial park
Town
City
County
Postcode

But I don't want (& what I get if I stick to default fields) is spaces, eg:

Contact

Company Name
Building no. & street name

Town

County
Postcode

 

[GShen]

Najemikon,
I would assume you did this already but then again you know what ASSUME stands for.
I have this is in a number of places. All I do is set the Can Shrink property to YES and it works. Obviously nothing can be on the same line. Not sure of your invoice format.
Let me know.

 

[Najemikon]

Really? That's it? Why do I always look for the hard way!

I'll try this over the next couple of days & I'll get back to you. Thank you very much!

 

[Najemikon]

Gshen, I finally tried my report again & it worked a treat. I was certainly assuming something, but it was entirely the wrong thing! I never knew the Grow/Shrink properties were quite so flexible.

You must excuse me, this was so straightforward, I have about two dozen old databases to go through!

Thanks again.

 

[GShen]

great to hear you good fortune. Maybe you can do me a favor. I posted a question for positioning to a record on a subform from the mainform. Have any ideas or places I could look. I would appreciate it.
Thanks.