Value list box values

[Paul Cooke]

Hi

I have a small issue with list boxes and wonder if ther is a fix for it.

I have two list boxes on a form 1 for Gender and one for Title.

At the moment, if a user types in 'M' in gender Male comes up which is correct, but if they typed in something like Mail or even '123' that stays in the list box and the focus moves to the next control.

I have got the properties set as:-

Limit To List as Yes
Allow Value List Edits as No
Inherit Value List as Yes
Show Only row Source Values as Yes

Is there a way to stop anything being entered in these controls apart from what is in the row source?

many thanks for any advice offered.

Paul

 

[CBrighton]

I have no experience with listboxes, but I wonder if the problem would persist if a combobox were used instead?

Certainly I've never had an issue with the LimitToList property on comboboxes.

 

[Paul Cooke]

Yep that was my thoughts as well about changing to combo's but to be honest I was hoping for an 'easy' fix (if there was / is one) to save me having to change them - hindsight is a wonderful thing or so they say !!

thanks for your reply

 

[CBrighton]

Out of curiosity, why did you use a listbox over a combobox?

The only time I use listboxes is for multiple selections, I haven't found any other situation where they are "better" than a combobox (mainly as a combobox takes up the same amount of space on a form as a textbox).

Don't get me wrong, I'm not criticising. I'm just trying to understand the reasoning as I rarely even consider using a listbox.

 

[Paul Cooke]

To be honest it was so long ago when I put them in I can't really remember why I did - lack of experience at the time most likely.

I've been building this DB for quiet a few months now and its finally gone on our system for some 'live' testing and I am just going through all the 'issues' that are arising as it is tested - thankfully there have not been that many (so far!!) but the value list bit has cropped up and is bugging me.

I know now I should of used combo's in the first place ... back to the hindsight saying !!