Access Reports

[Jean]

I am trying to put together some reports in Access and I want to include a
Name and Address section. My name and address fields in the tables allow
for multiple line addresses and therefore may have blank lines. When I use
the full complement of fields in my report I have gaps where there are blank
fields in the table.

Can anyone advise how I can suppress blank fields and/or move lines up if
the previous line is blank?

Also, I would like to insert fields in a text box to neaten up some of the
information - can anyone advise if this is possible and how I achieve it?

Thank you

Jean

 

[Guest]

Can anyone advise how I can suppress blank fields and/or move lines up if
the previous line is blank?

Look at the Properties of the textbox on the Report (this works on reports
but not on Forms): if you set the CanShrink property to True, the box will
disappear if its contents are null. You must be sure not to have it on the
same horizontal line as another textbox though.

Also, I would like to insert fields in a text box to neaten up some of the
information - can anyone advise if this is possible and how I achieve it?

This is easily done in a couple of ways. You can use an "unbound" textbox;
for example if you want a textbox to contain some constant "boilerplate"
text, simply set its Control Source property to

= "This Is the text I want to see"

If you want to concatenate table fields, you can do so either in the Query
upon which the Report is based, or in the Control Source. In the query just
type (frex)

CityStateZip: [City] & " " & [State] & " " & [Zip]

or in the control source property of a report textbox put the same
expression preceded by an = sign:

= [City] & " " & [State] & " " & [Zip]

John W. Vinson/MVP

 

[Jean]

Thanks John

This should do the trick.

Regards

Jean

Can anyone advise how I can suppress blank fields and/or move lines up if
the previous line is blank?

Look at the Properties of the textbox on the Report (this works on reports
but not on Forms): if you set the CanShrink property to True, the box will
disappear if its contents are null. You must be sure not to have it on the
same horizontal line as another textbox though.

Also, I would like to insert fields in a text box to neaten up some of
the
information - can anyone advise if this is possible and how I achieve it?

This is easily done in a couple of ways. You can use an "unbound" textbox;
for example if you want a textbox to contain some constant "boilerplate"
text, simply set its Control Source property to

= "This Is the text I want to see"

If you want to concatenate table fields, you can do so either in the Query
upon which the Report is based, or in the Control Source. In the query
just
type (frex)

CityStateZip: [City] & " " & [State] & " " & [Zip]

or in the control source property of a report textbox put the same
expression preceded by an = sign:

= [City] & " " & [State] & " " & [Zip]

John W. Vinson/MVP