Drop down list box

[drgarytraub]

Can the display be controlled a bit - such as how wide the columns are, the wisth of the entire table, etc.

[Selwyn Rabins]

RE: Drop down list box

yes it can.
where are you defining the drop down list box? in field rules- table lookup? if so, then just increase/decrease the column widths when you define the table lookup

[drgarytraub]

RE: Drop down list box

Great - thanks. Now, how can I make the list box pop up immediately upon entry. I don't seem to be able to do it through fields rules, or am I missing something? Do I need to use the OnArrive event of the field with the command that causes the lookup table to open (what is that command again??)

[drgarytraub]

RE: Drop down list box

Shouldn't this work:

I put sys_send_keys({%down}) in the CanArrive event of the fields.

When I do this, I get the error message:

Script: CanArrive line 15
sys_send_keys({%down})
invalid date constant

What am I doing wrong??

[Tom Patten]

RE: Drop down list box

Add the quotes

sys_send_keys("{%down}")

Tom

[drgarytraub]

RE: Drop down list box

Tom:

Thanks - that did the trick.

Gary

[whanigsberg]

RE: Drop down list box

Gary,

You never answered Selwyn's question when he asked if you were defining the list box in field rules or in form properties. If you are using field rules there is a "popup on entrance" setting. If the list is programmed into the form you may have to use keystrokes as above.

Bill

[Selwyn Rabins]

RE: Drop down list box

thanks Bill!!

[drgarytraub]

RE: Drop down list box

Sorry ... I have been trying both ways and experimenting with different effects. So far, I like defining the controls within the form itself - however, I have noticed a problem. I have 7 record list-combo boxes on the form. Now, when the form is loaded, the last few control fields paint slow enough that you can see the form painting - I hope this is clear. And thanks for all the help.


Gary

[drgarytraub]

RE: Drop down list box

Alos, I couldn't get the popup on entranbce to work within field rules. I must be doing something wrong.

[drgarytraub]

RE: Drop down list box

It seems like more than a few list combo controlson this form slows down the painting to a noticeable level. Converting 2 or 3 back to regular type in fields eliminates the problem. Is this normal?

[forskare]

RE: Drop down list box

I created a list box on a form with the tool bar and then selected the field. It works fine except that I can no longer make the selection by typing the word.

Previously, If I could choose from the following: Cash, Check, Money Order. If I typed ca, and pressed enter, Cash was selected. If I typed ch and pressed enter, check was selected. Now, this doesn't work at all.

ken

[drgarytraub]

RE: Drop down list box

Is there any way to get around this slow repainting issue?

[forskare]

RE: Drop down list box

Gary,

From what you say, it sounds like it occurs just for that feature? Frankly, I think it's a bug, particular to your setup. I've never experienced this nor have I heard of the issue.

How creating a test database with a couple of small tables and a few fields. See what happen's there. Perhaps it's something in the database???

BTW, which lookup are you using in the drop down list?

kenn

[drgarytraub]

RE: Drop down list box

Thanks for the reply Ken. I think it happens because I have a lot of fields on the form, and as the number of list-combo fields increases, you begin to notice the slow repainting.

BTW, which lookup are you using in the drop down list?

record list-combo box