change recordsource - lose number format

[don]

i have a subreport, where i may change recordsource depending on a form
value. When this occurs, a text box showing numbers on the sub report loses
its formatting (Standard). If I do not change the recordsource, the
formatting is fine for that text box.
I also tried re-setting the format immediately after setting the recordset,
still does not work..

 

[Marshall Barton]

i have a subreport, where i may change recordsource depending on a form
value. When this occurs, a text box showing numbers on the sub report loses
its formatting (Standard). If I do not change the recordsource, the
formatting is fine for that text box.
I also tried re-setting the format immediately after setting the recordset,
still does not work..

Is it possible that you changed record source query does
something(?) that causes the number field to be coverted to
a text string?