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
|
|||
|
|||
forms- is there a limit of fields on a form?
I was told that there was a limit of 255 fields per form but I did not see
that in the access specifications in the help file. It was suggested to me to maximize the use of subforms to overcome that limitation. True or false? Thanks -- dlazenby |
#2
|
|||
|
|||
You can see the list of specifications if you open Help from database window
and type Specification in the index. -- Ken Snell MS ACCESS MVP "dlazenby" wrote in message ... I was told that there was a limit of 255 fields per form but I did not see that in the access specifications in the help file. It was suggested to me to maximize the use of subforms to overcome that limitation. True or false? Thanks -- dlazenby |
#3
|
|||
|
|||
There is a limit of 255 fields in a table, but you can have more than 255
controls on a form, e.g. if 255 text boxes have attached labels, you already have 500 controls. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "dlazenby" wrote in message ... I was told that there was a limit of 255 fields per form but I did not see that in the access specifications in the help file. It was suggested to me to maximize the use of subforms to overcome that limitation. True or false? Thanks -- dlazenby |
#4
|
|||
|
|||
Thanks Allen,
I appreciate the info. Doug Lazenby "Allen Browne" wrote: There is a limit of 255 fields in a table, but you can have more than 255 controls on a form, e.g. if 255 text boxes have attached labels, you already have 500 controls. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "dlazenby" wrote in message ... I was told that there was a limit of 255 fields per form but I did not see that in the access specifications in the help file. It was suggested to me to maximize the use of subforms to overcome that limitation. True or false? Thanks -- dlazenby |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dialog Box | Antonio | General Discussion | 2 | July 13th, 2004 01:59 PM |
in forms, my labels and fields are not visible, | AccessAmatuerAgain (AAA) | General Discussion | 1 | June 23rd, 2004 07:30 AM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
matching multiple forms on open to form records | EdwardA | Using Forms | 0 | June 10th, 2004 06:38 PM |
formatting form fields and document | jrm | Formatting Long Documents | 1 | May 13th, 2004 06:12 PM |