hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino 5 2006
Does it help if you set the Not In List property of the combo?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"brino" <bd*************@yahoo.com.auwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...
hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino
On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Does it help if you set the Not In List property of the combo?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"brino" <bdsolutions2...@yahoo.com.auwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...
hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino
i couldnt find the "not in list" property on the table design.
i tried the "limit to list" property but this did not work.
i dont know what else i could do , i may have to change it to an
option group ???
thanks
brino
What happened when you set Limit To List to No?
What should happen is that if the user types something that is not in the
list, Access stops them from proceeding until they make a valid choice.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"brino" <bd*************@yahoo.com.auwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...
On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>Does it help if you set the Not In List property of the combo?
-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"brino" <bdsolutions2...@yahoo.com.auwrote in message
news:11**********************@n76g2000hsh.googleg roups.com...
hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino
i couldnt find the "not in list" property on the table design.
i tried the "limit to list" property but this did not work.
i dont know what else i could do , i may have to change it to an
option group ???
thanks
brino
(Set to Yes, of course)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:45**********************@per-qv1-newsreader-01.iinet.net.au...
What happened when you set Limit To List to No?
What should happen is that if the user types something that is not in the
list, Access stops them from proceeding until they make a valid choice.
"brino" <bd*************@yahoo.com.auwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...
>On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>>Does it help if you set the Not In List property of the combo?
-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"brino" <bdsolutions2...@yahoo.com.auwrote in message
news:11**********************@n76g2000hsh.google groups.com...
hi all !
i have a drop down list in a form. the users of the data base are typing text in there instead of selecting from the list. how can i make it so they cannot type text and only select what is in the drop down list.
thanks brino
i couldnt find the "not in list" property on the table design. i tried the "limit to list" property but this did not work. i dont know what else i could do , i may have to change it to an option group ??? thanks brino
On Mar 15, 8:27 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
(Set to Yes, of course)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Allen Browne" <AllenBro...@SeeSig.Invalidwrote in message
news:45**********************@per-qv1-newsreader-01.iinet.net.au...
What happened when you set Limit To List to No?
What should happen is that if the user types something that is not in the
list, Access stops them from proceeding until they make a valid choice.
"brino" <bdsolutions2...@yahoo.com.auwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...
On Mar 15, 6:43 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote: Does it help if you set the Not In List property of the combo?
>-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
>"brino" <bdsolutions2...@yahoo.com.auwrote in message
>>news:11**********************@n76g2000hsh.google groups.com...
hi all !
i have a drop down list in a form.
the users of the data base are typing text in there instead of
selecting from the list.
how can i make it so they cannot type text and only select what is in
the drop down list.
thanks
brino
i couldnt find the "not in list" property on the table design.
i tried the "limit to list" property but this did not work.
i dont know what else i could do , i may have to change it to an
option group ???
thanks
brino- Hide quoted text -
- Show quoted text -
thanks Allen this worked ok ! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Don Wash |
last post by:
Hi There!
I have a Server-side Drop-down box in ASP.NET (VB) page. What do I do to
widen the Drop down box's Pull-Down list's width?
I'm not talking about the Drop-down box's width but the box...
|
by: Leszek Taratuta |
last post by:
Hello,
I have several drop-down lists on my ASP.NET page. I need to keep data
sources of these lists in Session State.
What would be the most effective method to serialize this kind of data...
|
by: Yoshitha |
last post by:
hi
I have 2 drop down lists in my application.1st list ontains itmes like
java,jsp,swings,vb.net etc.2nd list contains percentage i.e it conatains the
items like 50,60,70,80,90,100.
i will...
|
by: Vigneshwar Pilli via DotNetMonster.com |
last post by:
string connectionString1 = "server=(local); user=sa;password=sa;
database=sonic";
System.Data.SqlClient.SqlConnection dbConnection1 = new
System.Data.SqlClient.SqlConnection(connectionString1);...
|
by: pmelanso |
last post by:
Hello,
I have a drop down list which is dynatically loaded from a database and
I have a second drop down list that is also dynatically loaded
depending on what is selected in the first drop down...
|
by: Ed Dror |
last post by:
Hi there
ASP.NET 2.0 VB & SQL Express
Lest take Northwind Categories Products as example
I create a table that hold these two together
and I create a stored procedure like
select ProductID,...
|
by: ashok893 |
last post by:
I'm using two drop down list ina form. I have generated the first drop down list from MySQL database. When i select an option from first drop down list, i have to generate second drop down list...
|
by: TycoonUK |
last post by:
Hi,
As I do not have IE7 on my computer, I was wondering if there is a
fault in my CSS Menu when using IE7.
Please can someone look at my site - http://www.worldofmonopoly.co.uk
and tell me...
|
by: penny111 |
last post by:
Hi there,
For my application, i need to have 3 drop down lists
1. drop down list of folder names
2. drop down list of documents in the folder selected
3. drop down list of instances of the...
|
by: abTech |
last post by:
Have struggled a lot to get a filtered drop down in the normal html and that too editable ... i have used table like auto-completion etc ... This is the simplest solution for a filtered drop down
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |