|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 16th, 2004, 05:17 PM
|
|||
|
|||
Table design error
Hello:
I am developing a table now. Whenever I saved my table, it shows "Property value is too large" and I could not save it. I checked all my field and did not find anything wrong. Any idea on this? Thanks in advance! 
|
|
#2
August 16th, 2004, 06:34 PM
|
|||
|
|||
|
We are having a little trouble seeing all your properties. What have you
tried in terms of trouble-shooting. Trouble-shooting generally involves removing stuff a bit at a time until it works. The last piece you removed was the cause of your problem. -- Duane Hookom MS Access MVP "Vincdc" wrote in message ... Hello: I am developing a table now. Whenever I saved my table, it shows "Property value is too large" and I could not save it. I checked all my field and did not find anything wrong. Any idea on this? Thanks in advance!
|
|
#3
August 16th, 2004, 07:11 PM
|
|||
|
|||
|
I tried to use combox "yes/no/unknown" for some fields. However, it works on
most of fields, but does not work on some fields. I used exactly same format. Even, I tried to delete the one and create a new field; it still does not field and gives me the same error message. Do not know why. Thanks "Duane Hookom" wrote: We are having a little trouble seeing all your properties. What have you tried in terms of trouble-shooting. Trouble-shooting generally involves removing stuff a bit at a time until it works. The last piece you removed was the cause of your problem. -- Duane Hookom MS Access MVP "Vincdc" wrote in message ... Hello: I am developing a table now. Whenever I saved my table, it shows "Property value is too large" and I could not save it. I checked all my field and did not find anything wrong. Any idea on this? Thanks in advance!
|
|
#4
August 16th, 2004, 09:04 PM
|
|||
|
|||
|
Don't use a lookup/combo box for any field in a table design
http://www.mvps.org/access/lookupfields.htm. BTW: if you want to do this, you can't set the row source of a combo box to "yes/no/unknown" except as to expect this to be a single value on a text type field. -- Duane Hookom MS Access MVP -- "Vincdc" wrote in message ... I tried to use combox "yes/no/unknown" for some fields. However, it works on most of fields, but does not work on some fields. I used exactly same format. Even, I tried to delete the one and create a new field; it still does not field and gives me the same error message. Do not know why. Thanks "Duane Hookom" wrote: We are having a little trouble seeing all your properties. What have you tried in terms of trouble-shooting. Trouble-shooting generally involves removing stuff a bit at a time until it works. The last piece you removed was the cause of your problem. -- Duane Hookom MS Access MVP "Vincdc" wrote in message ... Hello: I am developing a table now. Whenever I saved my table, it shows "Property value is too large" and I could not save it. I checked all my field and did not find anything wrong. Any idea on this? Thanks in advance!
|
|
#5
August 16th, 2004, 09:25 PM
|
|||
|
|||
|
Thanks!
I will try to avoid using combo box in the table design. "Duane Hookom" wrote: Don't use a lookup/combo box for any field in a table design http://www.mvps.org/access/lookupfields.htm. BTW: if you want to do this, you can't set the row source of a combo box to "yes/no/unknown" except as to expect this to be a single value on a text type field. -- Duane Hookom MS Access MVP -- "Vincdc" wrote in message ... I tried to use combox "yes/no/unknown" for some fields. However, it works on most of fields, but does not work on some fields. I used exactly same format. Even, I tried to delete the one and create a new field; it still does not field and gives me the same error message. Do not know why. Thanks "Duane Hookom" wrote: We are having a little trouble seeing all your properties. What have you tried in terms of trouble-shooting. Trouble-shooting generally involves removing stuff a bit at a time until it works. The last piece you removed was the cause of your problem. -- Duane Hookom MS Access MVP "Vincdc" wrote in message ... Hello: I am developing a table now. Whenever I saved my table, it shows "Property value is too large" and I could not save it. I checked all my field and did not find anything wrong. Any idea on this? Thanks in advance!
|
|
#6
August 17th, 2004, 11:52 AM
|
|||
|
|||
|
Pardon my intrusion...
How many fields do you have in your table? Have you run the Repair and Compact utility? -- Good luck Jeff Boyce Access MVP
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help w/ table design | Tom | Database Design | 0 | August 12th, 2004 02:34 PM |
| Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |
| Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
| Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
| Table design methodology... | clamfuddle | New Users | 4 | June 14th, 2004 07:53 PM |
Linear Mode
