Some formatting (control) questions

[Gunti]

Hi,
I've created a form, completely new to access. But it's coming along okay.

I've got a couple of questions.

I've got a form where people select a value from a list. 10 other boxes are
relying on this control to get their value. However, as soon as people open
this form. It automaticly sets the default value as the first value in my
table. I can not undo this by setting a 'default value' in the properties
setting.

Another question is that in the list box -> I want people to type their way
into a value. When they type VE it should jump to the first value which
starts with VE (for example Veteran). Currently it doesn't do this.

My final question is about a combo box. I've got one with about 9000 values.
The scroll bar doesn't work, however. When i hold it down completely it jumps
up & it's at about a quarter of my data. Any way to solve this??

Any answer to any of these questions is appreciated...

Greets,
Gunti

 

[Wayne-I-M]

I've got a form where people select a value from a list. 10 other boxes are

relying on this control to get their value. However, as soon as people open
this form. It automaticly sets the default value as the first value in my
table. I can not undo this by setting a 'default value' in the properties
setting.

It shouldn't do that try not having anything in the default row.
If that does not work can you post the source so people can look at it


Other questions see your other question answers

 

[BruceM]

Default value is the value assigned for a new record. What you are seeing,
I think, is that the recordset is opening to the first record. You could
let it do that, then use a search combo box; or you could select the value
in a pop-up form, then pass this value to the main form when it opens, or
you could open the form with no records, and either load only the record
selected from a search combo box or load a recordset to a selected record.
What exactly do you wish to do?

For your second question, you are referring to the autoexpand property,
which as far as I know is available for combo boxes, but not list boxes.

For your third question I am not sure I understand. What do you mean by
"hold it down completely"? What jumps up?

Here is a way of managing combo boxes with many records:
http://allenbrowne.com/ser-32.html

 

[Gunti]

Your first answer is spot on- i want it to be blank untill someone enters the
data.

About the scrollbox -> the middle bar you drag to scroll jumps up if i drag
it to the bottom. It SHOULD go to the lowest data, however. It jumps to the
middle & shows my data at about half the bar.

Greets & Thanks
Gunti

 

[BruceM]

Do I understand that you wish to open a blank form, then load a single
record when it is selected from the drop-down list?

Regarding the jumping scroll bar, I get that too with a large number of
records. I agree it would be good if a long list would go to the end, but
what should happen and what does happen are not always the same. Unless you
intend to select several values at once (multi-select list box) I would
suggest using a combo box instead, which has the autoexpand property you
want. You can also use the technique in the link I sent in my previous
reply to load the row source as the user types into the combo box.

 

[Peter Hibbs]

Gunti,

To get the combo-box scroll bar to work, enter this code in the Load
event of the form :-

Dim x as Long

combobox.Requery
x = combobox.ListCount

where combox is the name of your Combo box control.

However, I believe that a combo box can only display 65535 records
anyway (but I could be wrong).

HTH

Peter Hibbs.