MAX. columns in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top