AutoExpand Property 1

[RachelK]

When I created a form if you type the first part of information in a combo box ie bir in would aotomatically find Birmingham and you would just press eneter. when I created the form this works perfectly and as soon as I close the database and re-open the database this drops of and stops working any ideas why.

 

[TechieJr]

Hi RachelK,

I am having a similar problem with some forms I am working on. Have you found an answer?

I have gone into the combobox properties and changed the "Autoexpand" property to "No", closed the form, opened it again, set the "autoexpand" property to "Yes" and it works again - until I close the database and reopen it. Then I am back to the same problem.

Anyone else having this difficulty? Sure could use some help.

Regards,
TechieJr.

 

[hymn]

is your combobox coded or from a table

 

[TechieJr]

Hi Hymn,

I'm not quite sure what you mean by "coded" vs "from a table" but what I can tell you is this:

It is unbound, but based on the table the form is created on.

The Row Source Type is Table/Query

The Row Source is the appropriate two fields from the correct table and the Bound to is column 1, which should be fine.

It was created using the wizard which invokes when you drag the control over from the tool bar and if memory serves me correct, I chose the "Find a record based on the enty you choose" option.

Anything else I can tell that would be helpful?

Thanks for your help.

TechieJr.

 

[hymn]

In the properties do you have the line IME Sentence Mode set to Phase Predict

 

[KornGeek]

IME Sentence Mode?
I don't even see that in the properties of my combo boxes. Where do you find this?

 

[hymn]

what version are you using

 

[KornGeek]

I am using Access 2k.

 

[TechieJr]

Hi hymn,

For KornGeek's sake, the IME Sentence Mode is found on the "Other" tab in Access 2002. I don't know about previous versions.

My IME Sentence mode is set to "None". The IME Hold property is set to "No" and the IME Mode is set to "No Control".

Should the IME Sentence mode be set to "Phrase Predict"? What about the others? Anything else you want to know?

Thanks for your help.

TechieJr.

 

[hymn]

hold = no
mode = no control
sentence mode = Phrase Predict

Hope that this helps

 

[TechieJr]

Hello hymn,

Checked the IME Sentence Mode settings on several comboboxes and found that they were all set to "None". Changed some to "Phrase Predict" and it did not change the behaviour.

Did some digging in the Help file and found that IME is active only when Asian languages are in use. Does it really make a difference in English?

Any further suggestions as to what would cause this frustrating behaviour would be appreciated.

Thanks a bunch!
TechieJr.

 

[hymn]

I have tried to get problem and i still can't.

two tables
table A main table Called Tbl_Main
table B has abc in Called Tbl_DDDD

create form from table A let wiz do it or design view

on the field required to be Cbo in design view change to combo
in the properties for that field
Row Source Select [field name] from [Tbl_DDDD]

every time I do this the cbo works

Sorry

Hope this helps

 

[hymn]

I have browsed the books i have nothing in them

are you running the combo from a single table query, multi table query?

what version of Access are you using ?

Try Msdn.com
search on combo
Programming combo box and list box

Hope this helps

 

[hymn]

put you on a wrong path it should be

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office03022000.asp

sorry


hope this helps

 

[TechieJr]

Hi Hymn,

To answer your questions, I am using Access 2002 and buidling the db in 2002 mode.

The cbo is created right from the table. No query is involved.

Thanks for the MSDN link. I'll check it out. In the meantime, any further thoughts or ideas would be appreciated.

TechieJr.