Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2005

Tip: Looking for answers? Try searching our database.

formating a report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ms Jen - 26 Oct 2005 17:30 GMT
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)
fredg - 26 Oct 2005 17:44 GMT
> I have four fields I want in my report however I want them to self space....
>
[quoted text clipped - 10 lines]
> Thanks in advance
> ( I pretty sure this is an easy question, I just can't find the answer)

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.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Ms Jen - 26 Oct 2005 17:59 GMT
Dah kinda of like the Page x of y.... Your a gem

> > I have four fields I want in my report however I want them to self space....
> >
[quoted text clipped - 18 lines]
> Make sure the name of this control is not the same as the name of any
> field used in the expression.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.