Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / November 2004

Tip: Looking for answers? Try searching our database.

Adding field: Property value is too large

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chip Coutts - 17 Nov 2004 22:02 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.