How can I setup alternating formats on one page?

  • Thread starter Thread starter Kelvin Beaton
  • Start date Start date
K

Kelvin Beaton

I want to create a photo directory and would like the layout to be a 8 1\2 X
11 with two columns. That part I can fiugre out.

I'd like it to be like the following in one column.

Any help would be appreciated.

Kelvin

++++++++++++++++++++++++++

_______________________________

Information Photo
_______________________________

Photo Information
_______________________________

Information Photo
_______________________________

Photo Information
_______________________________
 
Kelvin said:
I want to create a photo directory and would like the layout to be a 8 1\2 X
11 with two columns. That part I can fiugre out.

I'd like it to be like the following in one column.

Any help would be appreciated.

Kelvin

++++++++++++++++++++++++++

_______________________________

Information Photo
_______________________________

Photo Information
_______________________________

Information Photo
_______________________________

Photo Information
_______________________________
Click to expand...

Add a table with the info and the link to the image as a record source.
Place the information as you need.

_______________________________

Information Photo
_______________________________

Photo Information
_______________________________

Group According to name.

This should give you repeated results for every record you have.

- Lance
 
Assuming you want to swap the Information and Photo controls for each record
The following assumes the information is a text box named txtInfo and the
photo is contained in an image control objPhoto.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim intPhotoLeft As Integer
Dim intInfoLeft As Integer
intPhotoLeft = Me.objPhoto.Left
intInfoLeft = Me.txtInfo.Left
Me.objPhoto.Left = intInfoLeft
Me.txtInfo.Left = intPhotoLeft
End Sub

You would need to make sure your report is wide enough to display either
control on the right side.
 
Thanks for the reply.

I don't see how to add a table to an Access report. I found a custom
"Tabular data control" but that doesn't look like the answer.

Could you point me in the right direction?

Thanks

Kelvin
 
Thanks for the reply.

I might have been a little miss leading with my example. I will look more
like the following.
---------------------------------------------------------------
Name Photo
Address
Phone
Email
---------------------------------------------------------------

Will your code work with this format?

Thanks

Kelvin
 
Yes, it should work with several controls/text boxes.

Try it and if you have trouble, paste your code into a reply with a
description of your issue.
 
Back
Top