Just a little thought,

does anyone know how, (if possible) how to have a report that has 2 fields on top of each other, and depending on which one of the two fields has data into it, the record will be displayed in the same part of the report

note that each record will only have data in one of the two fields at any one time. so regardless of which one has the data, the record will be always be displayed in the same part.

hope that makes sense

:)

Depending where on your report the textboxes are, behind the On_Format event of that section;

If isnull(Me.TextBox1) then
with me
.textbox1.visible = false
.textbox2.visible = True
else
.textbox1.visible = True
.textbox2.visible = False
end if
end with

:cool:

Thank you

You have taught me something new today.

No probs:)