Issue with Printing Forms

[rye1982]

Hello,

As an Access novice, I have created a rudimentary form that I use to print
invoices (I realize now that I should have used a report for this purpose,
but I am too fargone to change it now and it works quite well).

Anyway, my issue is this - I use the following (simplified) code to hide
certain fields on certain invoices on Form_Current():
If IsNull(Me.Variable) Then
Me.Variable.Visible = False
Me.Label.Visible = False
Else
Me.Variable.Visible = True
Me.Label.Visible = True
End If
However, when I go to print my most recent invoices, I click Print and
select the records that I want printed. But when printing, it will keep the
form format of my first record. That is, if record #1 has 'Variable' and
'Label' (above) hidden on the form, it will hide it on all records printed
(even if Visible = True for that record).

Is there a way to resolve this?

Any help would be appreciated. Thank you,

Ryan

 

[John W. Vinson]

Hello,

As an Access novice, I have created a rudimentary form that I use to print
invoices (I realize now that I should have used a report for this purpose,
but I am too fargone to change it now and it works quite well).

If you open the Form in design view, you can use File... Save As to save it as
a Report. It's certainly not too late to back out.

Anyway, my issue is this - I use the following (simplified) code to hide
certain fields on certain invoices on Form_Current():
If IsNull(Me.Variable) Then
Me.Variable.Visible = False
Me.Label.Visible = False
Else
Me.Variable.Visible = True
Me.Label.Visible = True
End If
However, when I go to print my most recent invoices, I click Print and
select the records that I want printed. But when printing, it will keep the
form format of my first record. That is, if record #1 has 'Variable' and
'Label' (above) hidden on the form, it will hide it on all records printed
(even if Visible = True for that record).

Is there a way to resolve this?

Conditional Formatting on the Format menu option in design view should let you
do what you want. It is available both for forms and for reports.