Access 2003 - Validation & Validation text in Forms does not work

T

T Goodson

This is the first time that I am using Access for development. I have a very
large Table, so large that when saving I kept getting a error that it
exceeded table size so, I had to take some fields out. I had all Validation
and error Text in Table. To give me more room in Table I moved ALL Validation
stuff to the Form. Before I did I checked Help and found the sequence of
Validation to be that Forms came before Tables. However, after I moved
everything (2 days) I tested in form view and found that none of my
Validation stuff now works. When I put one field back like it was it worked
perfectly. Help! I do not want to move all Validation stuff back to the Table.

All help would be greatly appreciated,
Tim
 
J

John Vinson

On Sun, 21 Aug 2005 14:45:16 -0700, T Goodson <T
This is the first time that I am using Access for development. I have a very
large Table, so large that when saving I kept getting a error that it
exceeded table size so, I had to take some fields out. I had all Validation
and error Text in Table. To give me more room in Table I moved ALL Validation
stuff to the Form. Before I did I checked Help and found the sequence of
Validation to be that Forms came before Tables. However, after I moved
everything (2 days) I tested in form view and found that none of my
Validation stuff now works. When I put one field back like it was it worked
perfectly. Help! I do not want to move all Validation stuff back to the Table.

All help would be greatly appreciated,
Tim
Click to expand...

Whoa. Some real questions here!

Your table is very "large": is it "tall" - many records? or (more
likely given the error) "wide", with very many fields? There IS no
limit on the size of a table in records (only the 2 GByte limit in an
entire database) but there is a limit of 2000 bytes actually occupied
in any single record: is that what you're getting? How many fields do
you have - and have you in fact properly normalized your data
structure? Maybe you need SEVERAL related tables rather than one
massive spreadsheet-style table!

Table Validation rules will NOT "take up any room" in the table and
removing them will not affect the occurance of the "record size"
error. So I think you're on the wrong tack there!

And, Forms do not have "validation rules". They have events; you can
use a Form's BeforeUpdate event to write VBA code which checks for the
validity (or otherwise) of a new record, and if you set that event's
Cancel parameter to true (after appropriately warning the user of
course), the record will not be added to the table.

Could you please post an example of your "validation stuff" and
explain how you want it to work, and what is in fact happening?

John W. Vinson[MVP]
 
Top