Line Spacing on a Report.

[dkinley]

Agree with Ken for simplicity .. do it in the source if it is based on a query.

I did a test, too, apologies - I was wrong, it has been awhile since I prettied reports. What goes in the brackets is the name of the control on the report. So you line would look like:

=[ControlNameofAddress] & Chr(13) & Chr(10) & [ControlNameofCity]

If you don't change it in the source of the report or the source is a table, you can keep the distinct address and city fields in the detail section - just set their visibility to false. But the above expression will work - I just told you incorrectly.

It also seems that vbCrLf will cause a parameter prompt. Who knew? ;]. The above reference will place the correct line feed into the control.

-dK

 

[vincet2009]

dk,

Take a look at this attachment. This is what my report looks like in design view. I really appreciate your time. I am not an expert by any means in Access, so some of your instructions are foreign to me. I just tried this last command and it did no seem to work. So, do you think that maybe if I positioned the fields just slight off this problem wont happen? Let me know what you think. Thanks again.

Vince

 

[dkinley]

No attachment was posted ...

The [ControlName .... ] is a reference to whatever the text box control name was of address and city. Then set the ones you have to invisible. This step is not necessary if you do the concantenation in the query.

If you would like, copy the db, strip out all the data and make up one dummy record for the report and post the db and I can take a look at it tomorrow night unless someone else does it first.

-dK

 

[Rich]

vbCrLf is a VBA command and is not useable in the control source for a text box, use something like
=[FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address1] & Chr(13) & Chr(10) & IIf(IsNull([City]),"",[City] & Chr(13) & Chr(10)) & [PostalCode]

 

[gemma-the-husky]

is this fixed yet

seems to me - either

a) slide the occupancy textbox so its aligned with the "Gilroy" box, then that will fix that, but it might not look so pretty

so
b) make the "street name" and the "gilroy" boxes hidden, and have another box in their place called txtAddress or something (might need cangrow = true), and make this

=[streetnamebox] & vbcrlf & [gilroybox]

if it objects to vbcrlf then it might need to be
=[streetnamebox] & chr(13) & chr(10) & [gilroybox]

that should fix it