Combo Box Error

[Blackwidow]

I have a combo box on one of my forms linked to tblreason which is a list of reasons which need to be selected... one of them is "to settle to work and to stop distracting other students" the text field is set to length 255 in the table but everytime someone selects this option it comes up with a message "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data"..

I have checked the width of the box and it is long enough...

does anyone know why this is happening? No doubt a really obvious answer!!

 

[Mile-O]

What's the RowSource of the combo?

What's the structure of the table you refer to?

What's the ColumnCount of the combo?

What's the BoundColumn of the combo?

 

[Blackwidow]

What's the RowSource of the combo?
SELECT [tblReason].[Reason] FROM tblReason ORDER BY [tblReason].[Reason];

What's the structure of the table you refer to?
ReasonID - Autonumber
Reason - Text

What's the ColumnCount of the combo?
ColumnCount = 1

What's the BoundColumn of the combo?
1

 

[Mile-O]

SELECT [tblReason].[Reason] FROM tblReason ORDER BY [tblReason].[Reason];

Change this to:

Set it to SELECT ReasonID, Reason FROM tblReason ORDER BY Reason;

ColumnCount = 1

Set it to 2.

Your underlying field should be numeric.

 

[Fizzio]

Mile-O, you are supposed to answer the question, not ask more tsk

What are you trying to do with the combobox text? - if you are trying to add it to another table, make sure that the length of that field is set to accept the text. However, you should not need to duplicate this information more than once in your Db and should store the unique ID associated with it.

This problem smacks more of poor structural design rather than anything else - make sure that your tblReason is linked via the Reason_ID and not duplicating text all over your Db. If you have a good structure, accept my apols.

Mile-O has asked very relevant q's (despite my comment - just like winding up the jocks) but more specifically what type of field are you trying to store the value selected from the combo?

Edit: Bugger, Mile-O still has the fastest fingers in the North

 

[Blackwidow]

Its fixed thanks very much!

Thank you milo for pointing out that might structure sucks!! I am aware of this it is diabolical! but am doing my very best on my own here... no training... learnt all on my own, with no help.. been shoved in the deep end without any armbands!

Please forgive me for crusifying what could be an exceptional database

 

[Blackwidow]

sorry Milo message with regards my diabolical database intended for Fizzio

Message in thanks intended for you my sweet pea!

 

[Mile-O]

my sweet pea!

Aww!

 

[Mile-O]

am doing my very best on my own here... no training... learnt all on my own, with no help.. been shoved in the deep end without any armbands!

The exact same thing happened to me 2 years ago.

 

[Fizzio]

Hey Blackwidow, we all started in the same boat, some (such as Mile-O the genius) learned a little quicker than the rest of us (and he still types quicker than me - younger fingers, more time!)

No offence meant about the structure - just had a feeling that is all.

 

[Mile-O]

we all started in the same boat, some (such as Mile-O) learned a little quicker than the rest of us

Some say I went down to the Crossroads and sold by soul...

 

[Fizzio]

What for, a packet of crisps and a 20p mix-up?

 

[Mile-O]

What for, a packet of crisps and a 20p mix-up?

I'm not that posh!

 

[Blackwidow]

Thank you for your understanding

 

[Fizzio]

I'm not that posh!

Hmmm, good point!

Nae Bother BW.

 

[Mile-O]

I'd settle for the crisps.