Wrap info on report (1 Viewer)

Gr3g0ry

Registered User.
Local time
Today, 14:08
Joined
Oct 12, 2017
Messages
163
how do i wrap information on my report ? i have a query that returns 26 fields but they are all places in the same line in my report design. how can i change this ?

Also, is it possible to drag the various pieces of information to anywhere on the report to kinda setup my report the way i want it ?
 

isladogs

MVP / VIP
Local time
Today, 21:08
Joined
Jan 14, 2017
Messages
18,186
Add line breaks in the code used to populate the report textbox
Use either vbNewLine or vbcrlf - both do the same thing

In design view you should be able to drag report controls anywhere you like
Having said that, if you use a wizard, I believe Access may impose them on a grid which makes editing the design more difficult
 

Mark_

Longboard on the internet
Local time
Today, 14:08
Joined
Sep 12, 2017
Messages
2,111
If you are having issues rearranging in Design view, click on "ARRANGE" in the highlighted "REPORT DESIGN TOOLS". Click on those controls you wish to move (probably all) and click the "Remove Layout" button up top to the left.

You can now move around your controls. Remember to include labels that you wish to move as else they will continue to be a pain every time you choose to sit.
 

isladogs

MVP / VIP
Local time
Today, 21:08
Joined
Jan 14, 2017
Messages
18,186
Thanks Mark

As I never use the wizard I'd forgotten how ...
 

Gr3g0ry

Registered User.
Local time
Today, 14:08
Joined
Oct 12, 2017
Messages
163
thanks alot guys fixed those issues.
 

Users who are viewing this thread

Top Bottom