Strange problem with Report Veiw/Print

[Coleen]

I have a form that I have duplicated as a report. It uses a
sub-form/sub-report and has combo boxes with either a Yes or No selection.
In the Form this works fine and shows up correctly. In the report, if you
run the sub report data you can see that the data is saved correctly as Yes,
but when you try to print the report, the report shows this field as No.
This makes no sense...the report shows No in a field that is stored
correctly as Yes. I've double checked that there isn't a default value set
to No, and there isn't. Here is the SQL from the Sub-Report:

SELECT Emission_ID, Vehicle_ID, Air_Injection, Catalyst, EGR,
Fuel_Inlet_Restrictor, Fuel_Cap,DLC, MIL, Catalyst_ldd, EGR_LDD,
Crank_Case_Vent, Fuel_Cap_LDD, Mfg_Advt_Rated_HP,.Dynamometer_Spd,
Dynamometer_HP
FROM [Emission Tests];

The field that is coming in as No when the data shows Yes is Fuel_Cap. Most
all of these fields are set up as Combo boxes with Yes;No as the row source
and Row Source Type is Value list. None of the other fields show up
incorrectly...any suggestions?

TIA,

Coleen

 

[Duane Hookom]

Set up a text box with a control source like:
=IIf([Fuel_Cap] = True,"Yes","No")
This assumes the field type is yes/no. If it is text then don't use a combo
box or list box, just a text box.

 

[Coleen]

Thank you!

Set up a text box with a control source like:
=IIf([Fuel_Cap] = True,"Yes","No")
This assumes the field type is yes/no. If it is text then don't use a combo
box or list box, just a text box.

--
Duane Hookom
MS Access MVP

I have a form that I have duplicated as a report. It uses a
sub-form/sub-report and has combo boxes with either a Yes or No selection.
In the Form this works fine and shows up correctly. In the report, if you
run the sub report data you can see that the data is saved correctly as
Yes,
but when you try to print the report, the report shows this field as No.
This makes no sense...the report shows No in a field that is stored
correctly as Yes. I've double checked that there isn't a default value
set
to No, and there isn't. Here is the SQL from the Sub-Report:

SELECT Emission_ID, Vehicle_ID, Air_Injection, Catalyst, EGR,
Fuel_Inlet_Restrictor, Fuel_Cap,DLC, MIL, Catalyst_ldd, EGR_LDD,
Crank_Case_Vent, Fuel_Cap_LDD, Mfg_Advt_Rated_HP,.Dynamometer_Spd,
Dynamometer_HP
FROM [Emission Tests];

The field that is coming in as No when the data shows Yes is Fuel_Cap.
Most
all of these fields are set up as Combo boxes with Yes;No as the row
source
and Row Source Type is Value list. None of the other fields show up
incorrectly...any suggestions?

TIA,

Coleen