Is There A Maximum Size Of Field Caption Property In A Table?
Using access 2000 (because that is what client has). I have a table with a large # of fields, 209 at present but it will come down a few when test fields are removed. I am setting a descriptive caption on the fields to display as labels when they are placed on a form. Most captions are 2 – 4 words but a few are longer until we see the display on the form and finalize it. But at about 140 fields I can not enter anymore captions! I get a “Property value is too large” error (Jet Error 3309) when saving the table. If I go back and delete a caption on a previous field then I can enter one on the next field (which gave the error before). This makes it seem like there is some limit to the total space allocated for storing captions. It does not seem to have a character by character relationship (if I remove 1 character from a previous caption I can not add a 1 charcater caption to another field, but there may be other overhead sotred as well). Is this a default set somewhere that can be change
Related Questions
- I am a builder by trade and would like to purchase a piece of land and build my own property. What is the maximum build size and would I have to engage an architect?
- In Section II (Award Information), is the expected maximum award size (given in the table) per year or per duration of the project?
- There is a particular base I like. What is the maximum table top size it can accommodate?
