lock the editing of combobox text

[Grooz13]

Hello
I want my users to be able to always change the combobox but only with the data from the combobox...

let's say I have

doors
windows
floors


ceiling

those are the only 4 values i want

but in access if I select let's say doors and I click on the combox box the users can change the text to

doorsasdafege or just plain nothing

In validation rule I puted is not null
and I limited to list but limit to list only works on new record... if I want to edit an already exisiting records it doesn't raise an error

[Toyman]

Hello
I want my users to be able to always change the combobox but only with the data from the combobox...

let's say I have

doors
windows
floors
ceiling

those are the only 4 values i want

but in access if I select let's say doors and I click on the combox box the users can change the text to

doorsasdafege or just plain nothing

In validation rule I puted is not null
and I limited to list but limit to list only works on new record... if I want to edit an already exisiting records it doesn't raise an error

Set the combo box's property to "Limit to List". Any subsequent value, even existing record will be limited

[Grooz13]

no it does not i tried it if i write in the an already filled combobox it doesn't raise any error

[Toyman]

no it does not i tried it if i write in the an already filled combobox it doesn't raise any error

I just ran this in Access 2010. If the existing value in the table is not already complying with the value in the list, then the existing value stands. However, if you try to change the value to another value other then values in the list, then the error pops up. Also, ensure the Allow Value List Edit is set to no. This will prevent your users from adding new values to the row source

[Grooz13]

welll i'm in access 2007 and it doesn't work

[Grooz13]

but can't I just remove the possibility to enter text and only use the arrow ?

[Toyman]

but can't I just remove the possibility to enter text and only use the arrow ?

No, when you choose a value from the list, you are accually entering text, but from the list, therefore, the property for the field cannot be locked. Also, I just checked the limit to list setting in my Access 2007 version, and it worked just like in 2010. No other value can be entered into the field even if the record already exist. You might post your db here so we can take a look to see what is happening

[Grooz13]

ok I will post it but it's in french
when it loads

click on COMMANDE
and the combobox are the combobox in the subform

if i write anything in the combobox where it's written portes and then click on autres2 no error is raised

oops forgot to put it

[Toyman]

No, when you choose a value from the list, you are accually entering text, but from the list, therefore, the property for the field cannot be locked. Also, I just checked the limit to list setting in my Access 2007 version, and it worked just like in 2010. No other value can be entered into the field even if the record already exist. You might post your db here so we can take a look to see what is happening

Wait, are you saying that your user can change the value to "no value" and you tried to use "No null" value for the field?

If this is what you meant, then what you can do to prevent a blank value is put the following code in the after update event of the field:

Dim sValue as string
sValue = Nz(YourFieldName,"")
if sValue = "" then
Msgbox "You must enter something",vbInformation
Exit Sub
End If

[Grooz13]

no my is not null is just a different validation

[Grooz13]

i putted my bd in my post above yours

[Toyman]

no my is not null is just a different validation

Ok, your combo box was not set to limit to list = yes and it allow editing of the list. I changed it. Hope this works

[Grooz13]

if I change anything written where PORTES is written there is nothing happening

[Toyman]

if I change anything written where PORTES is written there is nothing happening

Ok, I changed the Inherit Value List = No and Show Only Row Source Value =yes. I further change the property setting for the field in the table to a text box instead of a combo box. This seems to fix the problem.

[Grooz13]

You sir are my savior thx for everything and all the time you put into my problem !

Solved !