Field wont print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field on a report that won't print when the user clicks the print
command button, but that same field will print if you do a print preview and
click print on the toolbar. Any ideas on why this is happening?
 
What is the difference between this text box and other controls on your
report?
 
There is a nested if statement, but it works fine if you do a print preview
and then print the report. I don't find any other differences.
 
This is the nested IIf statement. To add to the mystery, I have discovered
that all names will print with the exception of those with initials MM and MB.

=IIf([HR Personnel]="RR","Ronald Richard",IIf([HR Personnel]="LG","Linda
Guidry",IIf([HR Personnel]="MM","Michael Martens",IIf([HR
Personnel]="JV","John Vidrine",IIf([HR Personnel]="SG","Shane
Guillory",IIf([HR Personnel]="CB","Chad Burns",IIf([HR
Personnel]="MB","Matthew Broussard"," ")))))))
 
I would never create or maintain an expression like this.

Have you considered creating a small lookup table with initials as a unique
primary key, FirstName, and LastName? You could then join the talbe into
your report's record source and bind your text box to
=[FirstName] & " " & [LastName]

Seven nested IIf()s is about six too many.

--
Duane Hookom
MS Access MVP
--

Linda said:
This is the nested IIf statement. To add to the mystery, I have
discovered
that all names will print with the exception of those with initials MM and
MB.

=IIf([HR Personnel]="RR","Ronald Richard",IIf([HR Personnel]="LG","Linda
Guidry",IIf([HR Personnel]="MM","Michael Martens",IIf([HR
Personnel]="JV","John Vidrine",IIf([HR Personnel]="SG","Shane
Guillory",IIf([HR Personnel]="CB","Chad Burns",IIf([HR
Personnel]="MB","Matthew Broussard"," ")))))))
--
Linda


Linda said:
There is a nested if statement, but it works fine if you do a print
preview
and then print the report. I don't find any other differences.
Click to expand...
Click to expand...
 
Thanks! I will try this and see how it works. I appreciate your help and
will let you know how it goes.
--
Linda


Duane Hookom said:
I would never create or maintain an expression like this.

Have you considered creating a small lookup table with initials as a unique
primary key, FirstName, and LastName? You could then join the talbe into
your report's record source and bind your text box to
=[FirstName] & " " & [LastName]

Seven nested IIf()s is about six too many.

--
Duane Hookom
MS Access MVP
--

Linda said:
This is the nested IIf statement. To add to the mystery, I have
discovered
that all names will print with the exception of those with initials MM and
MB.

=IIf([HR Personnel]="RR","Ronald Richard",IIf([HR Personnel]="LG","Linda
Guidry",IIf([HR Personnel]="MM","Michael Martens",IIf([HR
Personnel]="JV","John Vidrine",IIf([HR Personnel]="SG","Shane
Guillory",IIf([HR Personnel]="CB","Chad Burns",IIf([HR
Personnel]="MB","Matthew Broussard"," ")))))))
--
Linda


Linda said:
There is a nested if statement, but it works fine if you do a print
preview
and then print the report. I don't find any other differences.
--
Linda


:

What is the difference between this text box and other controls on your
report?

--
Duane Hookom
MS Access MVP
--

I have a field on a report that won't print when the user clicks the
print
command button, but that same field will print if you do a print
preview
and
click print on the toolbar. Any ideas on why this is happening?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top