I have a Replicated database in Access 2000. I am trying
to add some fields to a table. Adding certain fields
generates an error message: "Property value is too
large." When I click on Help, I only get a grey screen.
When I try to save, there is the message "Errors
encountered during save operation." Access saves the new
field, but does not save some of the other attributes,
such as Default Value, Format and Input Mask.
The following are generating errors:
Field is Text, Size 1, and I want Default Value to be ""
Field is Date/Time, and I want the Format to be m/d/yyyy
hh:nn a/p and the Input Mask to be 99/99/0000\ 99:00\
a\m;0;#
How can I add these fields to my table, and make the
attributes stick?
Thanks.
Chip.
Cheval - 18 Nov 2004 21:59 GMT
Add the Data/Time one first and save, then the other, as I think the problem
lies with the text box and the default value of Empty String.
I'd recommend not setting the default value to an empty string. Just use the
Nz() function to test for null.
I have a Replicated database in Access 2000. I am trying
to add some fields to a table. Adding certain fields
generates an error message: "Property value is too
large." When I click on Help, I only get a grey screen.
When I try to save, there is the message "Errors
encountered during save operation." Access saves the new
field, but does not save some of the other attributes,
such as Default Value, Format and Input Mask.
The following are generating errors:
Field is Text, Size 1, and I want Default Value to be ""
Field is Date/Time, and I want the Format to be m/d/yyyy
hh:nn a/p and the Input Mask to be 99/99/0000\ 99:00\
a\m;0;#
How can I add these fields to my table, and make the
attributes stick?
Thanks.
Chip.