Issue with Printing Forms

  • Thread starter Thread starter rye1982
  • Start date Start date
R

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
 
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).
Click to expand...

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?
Click to expand...

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.
 
Back
Top