design Report

[Rasha]

in my report i design the output data to show as follow
wall finishes ..................................5
door height....................................200
door width......................................100
Drain............................................. ...Yes
Floor Drain.......................................No
now i wanna to display this ...................


when the returned data from table be string as 5 or any text
i make the text box to have the formula ="..........................."&[field name]
But in case of Yes/No because this is Lookup in my table design. cann't use the same formula
now i need a formula written in the text box to give me the same result when the data come from table is Yes/No or any lookup data
Thank You

[June7]

Try:

="..........................." & IIf([field name]=True, "Yes", "No")