-----Original Message-----
Answer to question 1:
Nz(Forms!Form_name![Textbox_name],0)
Answer to question 2
if your table field is called Field1)
Place this instead of Field1 in the query.
IIf([Field1]=1,"Slow", "Fast")
See Access help for explanation of the IIf function
hope this helps.
-----Original Message-----
1st Question
Is there a way to make a text box in a report where the
Control Source is a calculated text box on a form (ie the
form text box does not come from a table)? If so what is
the expression. I tried using Nz([form name].Form!
[textbox name],0) but the report will not recognize it.
2nd Question
I have a Option Group on the form that spits out 1 or a 2
into a field in the table. When I run a query on a "2" I
don't want the report to say "2", I want it to say what
the 2 means (ie If 1 = "Slow", 2 = "Fast", when I run a
query on 2 or "Fast", I don't want the report to say 2, I
want it to say "Fast")
Thank You in advance
.
.
