If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
change recordsource - lose number format
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.. |
#2
|
|||
|
|||
change recordsource - lose number format
don wrote:
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? -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|