Hi all,
I have a form with several combo boxes. I would like the users to be able to start typing in the field and it automatically completes the box. Can someone tell me how to get my form to autocomplete
Thanks
autocomplete
Hot Topic
- Unable to infopath form in browser
- Hide/unhide
- Get Current Slide Number And Insert a New Slide
- Can you use VBA to access a spread sheet embedded in a word doc?
- Error setting range to hidden in Excel 2003, not in 2000
- Excel Advanced filter critera Question...
- Newbie in VBA Drag and Drop..
- .onAction assign value
- User form issue
- [OTP] VBA Using combobox in Excel
Microsoft ISV
- How to convert excel file to .DAT file?
- 0x62304390 referenced memory
- Working with a DLL
- Running a macro if new mail if from a specific address
- Office Word Macro - create file to a specific directory
- Comput Cluster
- IsError function from VBA6.3 to v6.0
- How to get the date of the next coming Monday?
- Can't make ISEVEN() work
- .lookin =
autocomplete
cues7a
Hi,
You can use
AutoComplete* properties to accomplish this task.
If you want to give your own list for suggestion use AutoCompleteCustomSource, You can also set mode either suggest or change by setting AutoCompleteMode, There are also few builtin Source you can set them by setting AutoCompleteSource.
Now for example you add two values in collection of AutoCompleteCustomSource Saml and Martin and set AutoCompleteSource to CustomSource then when you type S it will suggest you Saml if your AutoCompleteMode is suggest.
Hope this help.
jianghongtu
Hena
Where's the autocomplete property. I right click on the properties of the form and field and I don't see it.
Thanks