change recordsource - lose number format

  • Thread starter Thread starter don
  • Start date Start date
D

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..
 
don said:
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..
Click to expand...


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