property value is too large

[uksoldier]

Help !

Got a DBase that was working fine this morning..... have updated the main dbase to include Combo Boxes with Value Lists.

I went to save and got the following error:

property value is too large

I have not added any fields so what could be the problem ?!

 

[FoFa]

Sounds like the value (from your value list) is to big to be stored in the bound column.

 

[uksoldier]

ERROR

Nope....

Through Trial and Error I have managed to save the DBase.

If I try to put in any values in the value list I get the error.... as if the DBase is full !!

As soon as I take out the values that push it over the edge it saves as normal...

 

[jfgambit]

Have you tried to Run a Compact and Repair on the Database?

 

[FoFa]

I could not find it in help, but I have not been that impressed with XP help. Any way a list box appears to be limited to 50 characters per list value. At least Office XP version will not let me enter more than 50 chars per list item. I don't have an older version to try it on any more, so I can't say for sure what they would allow or not.

 

[jfgambit]

In the table where the field resides, check the field size. If it is a text field you can set it up to 250 characters.