Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-20-2019, 04:53 PM   #1
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Field too small error on combo box

Hello,

I have a form with a combo box for "Title", the options are Mr., Mrs, Miss, Ms, and Dr. I have the value set for Short Text, 50 characters, yet I am getting this error. Has anyone run across this or have any idea what is happening?

Lkwdmntr is offline   Reply With Quote
Old 09-20-2019, 05:19 PM   #2
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 935
Thanks: 10
Thanked 191 Times in 181 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Field too small error on combo box

The 50 character setting you refer to is on the field that you'll be storing data in (assuming the combo is bound) and not on the field that provides the combo list items, yes? Then check the bound field for any data validation settings that are not correct, such as "= > 50" because that would mean the field must contain at least 50 characters.
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 09-20-2019, 05:27 PM   #3
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Field too small error on combo box

The field is not required, has no validation settings, allow zero length is "yes". Not sure what the problem is. The field is bound to my "Users" table.

Lkwdmntr is offline   Reply With Quote
Old 09-20-2019, 05:46 PM   #4
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 935
Thanks: 10
Thanked 191 Times in 181 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Field too small error on combo box

You don't say when this is happening. Upon combo selection/update? Moving off of or saving the record? Is there a query behind the form that's involved? Choosing a combo list item doesn't initiate any record save by any chance?
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 09-20-2019, 06:18 PM   #5
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Field too small error on combo box

It happens when I choose a title. It keeps the title and lets me continue, but I can't have an error popping up. Very confused about this one.
Lkwdmntr is offline   Reply With Quote
Old 09-20-2019, 06:42 PM   #6
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 935
Thanks: 10
Thanked 191 Times in 181 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Field too small error on combo box

I'm out of ideas, but then again, you don't answer every question. If you can post a db copy I'll take a look and see if I can spot the problem.
Micron is offline   Reply With Quote
Old 09-20-2019, 07:42 PM   #7
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Field too small error on combo box

Sorry if I didn't answer all the question. It's been a long day and my brain is kinda fried.

I just recreated the field in the table and reinserted into the form, thinking that might help, but same error.

There is no query, I am just using this form to add new records to my Users table. I used the Lookup Wizard and made a list, Mr., Mrs., Ms., Miss, and Dr.

I am using short text, 255 characters. Really am stumped on this one.

Lkwdmntr is offline   Reply With Quote
Old 09-20-2019, 10:10 PM   #8
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,426
Thanks: 68
Thanked 2,709 Times in 2,594 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Field too small error on combo box

check how many columns your combo has.
if 2, remove the first, and change the number of columns, column widths of your combo.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-21-2019, 04:50 AM   #9
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Field too small error on combo box

columns are set to 1 and the column width was 1", changed it to 2" and still getting the error. Help!
Lkwdmntr is offline   Reply With Quote
Old 09-21-2019, 05:01 AM   #10
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,142
Thanks: 81
Thanked 2,010 Times in 1,958 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Field too small error on combo box

Post a copy of the database in zip format with instructions for getting the specific error.

Most do not use the Lookup Wizard but here's a video on how to use it.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by jdraw; 09-21-2019 at 09:11 AM.
jdraw is online now   Reply With Quote
Old 09-21-2019, 08:25 PM   #11
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Field too small error on combo box

I just did a little experimenting. I switched around the Title field with the Date field and now the Date field is giving me the "Field too small error" and the Title field is not. So, this is telling me that the error is happening to the first field in the form. The Date field has a Date value with a date picker. I thought this newfound information would produce a different solution.
Lkwdmntr is offline   Reply With Quote
Old 09-21-2019, 08:37 PM   #12
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Field too small error on combo box

Another thought, what if it is giving the error when the autonumbered UserID field is generated. It isn't until I put something into a field in the new record that the UserId is generated. That is the same time I get the "Field to small error". I have a feeling it has nothing to do with the Title field or the Date field, but its the UserId Field generating a number. Its value is set to Long Integer, the only other option is "Replicate ID", not sure what that's for. Does this make sense to anyone???
Lkwdmntr is offline   Reply With Quote
Old 09-22-2019, 06:56 AM   #13
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 935
Thanks: 10
Thanked 191 Times in 181 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Field too small error on combo box

I for one will have to bow out. You've been asked twice to post a db copy. If you cannot, you could at least have the courtesy to respond to such suggestions so that we're not repeatedly asking for the same thing, or asking the same questions in order to get answers.
Good luck.
Micron is offline   Reply With Quote
The Following User Says Thank You to Micron For This Useful Post:
MajP (09-22-2019)
Old 09-22-2019, 08:30 AM   #14
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Field too small error on combo box

Micron,
I apologize for not posting the database, the size is too big to post on Access World. Mike60Smart asked me to post a copy as well, but he left an email address. I did share it with him.

Honestly, this is a lot of important information and I feel a little odd posting it for the whole world to see.

I do appreciate all the help from everyone here on Access World, still a little new to all of this. I'm in college finishing my first degree and also doing a Coding Bootcamp. This project is for a Co-op I am involved in for school. It is a start-up company and there is no-body to turn for help.
Lkwdmntr is offline   Reply With Quote
Old 09-22-2019, 11:15 AM   #15
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,142
Thanks: 81
Thanked 2,010 Times in 1,958 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Field too small error on combo box

Quote:
I apologize for not posting the database, the size is too big to post on Access World.
When you have an issue with a database that is quite large, or contains some personal/private info, a common strategy is to make a copy of the database and remove most of the data. Focus on a few test records and "experiment" with a few facts/criteria. If it involves a "complex" query, break it into smaller queries and attack the issue systematically/incrementally. If it's related to vba code, then step through code and try to pin point the issue.

You should be testing on a copy of your database after having made at least one backup -things tend to go surprisingly wrong when you test with a live database.

As mentioned, you can post a copy of a test database with only a few records.
You could modify your data in the test database to protect anything personal/private.
Names like Porky Pig, Paige Turner, General Purpose, Owen Money... Central City, Upstate etc. are quite effective -communicate without divulging anything personal.

Also you can anonymize/randomize your data. See this thread for more info on Randomizing your data. If you do Randomize-Make sure you are working with a copy of your database.

Good luck with your project.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by jdraw; 09-22-2019 at 12:25 PM.
jdraw is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Error Message: the field is too small... LeonDixon General 4 09-17-2014 02:47 PM
Error 3163: The field is too small to accept the amount of data you're tryng to add Alc Queries 7 12-20-2013 11:02 AM
Error 3163 field too small....needs memo field? wmrainer Modules & VBA 11 06-21-2013 10:20 AM
Error: Field is too small to accept amount of data Ammarhm Modules & VBA 14 07-23-2011 04:52 PM
dcount error 'field too small to accept amount of data' Happy YN Modules & VBA 5 04-10-2003 08:14 AM




All times are GMT -8. The time now is 05:13 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World