MAX. columns in a query

[Guest]

I have a billing form that has more than 286 fields on it, I need to print
data on this form, but the number of fields exceeds the query max of 255 for
the number of columns. Is there anything else I can try to accomplish this?

TIA

 

[Michel Walsh]

Hi,


Not directly. You may open a recordset and push values from the recordset to
unbound controls, as required. You will have to position the recordset
accordingly, through code. In a report? the onFormat subroutine event
handler sounds a good place for that.


You are still limited to 750+ controls, in a form (and I assume, in a
report too). I can' check at the moment (help file, Access Specifications),
over all its time life (ie, include those you deleted too, in that count).



Hoping it may help,
Vanderghast, Access MVP