formating a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have four fields I want in my report however I want them to self space....

Example (If I just add them to the report)

151 Test Message JPrater 10/15/05
151 Enter Message Wedwards 10/15/05

I want

151 Test Message JPrater 10/15/05
151 Enter Message Wedwards 10/15/05

Thanks in advance
( I pretty sure this is an easy question, I just can't find the answer)
 
I have four fields I want in my report however I want them to self space....

Example (If I just add them to the report)

151 Test Message JPrater 10/15/05
151 Enter Message Wedwards 10/15/05

I want

151 Test Message JPrater 10/15/05
151 Enter Message Wedwards 10/15/05

Thanks in advance
( I pretty sure this is an easy question, I just can't find the answer)
Click to expand...

Add an unbound control to the report.
Set it's control source to:
=[Field1] & " " & [MessageField] & " " & [NameField] & " " &
[DateField]

Make sure the name of this control is not the same as the name of any
field used in the expression.
 
Dah kinda of like the Page x of y.... Your a gem

fredg said:
I have four fields I want in my report however I want them to self space....

Example (If I just add them to the report)

151 Test Message JPrater 10/15/05
151 Enter Message Wedwards 10/15/05

I want

151 Test Message JPrater 10/15/05
151 Enter Message Wedwards 10/15/05

Thanks in advance
( I pretty sure this is an easy question, I just can't find the answer)
Click to expand...

Add an unbound control to the report.
Set it's control source to:
=[Field1] & " " & [MessageField] & " " & [NameField] & " " &
[DateField]

Make sure the name of this control is not the same as the name of any
field used in the expression.
Click to expand...
 
Back
Top