combo box behavior

  • Thread starter Thread starter RipperT
  • Start date Start date
R

RipperT

Hey, all,

I have a combo box that lists the values from a field in
another table. The input mask of this field is 0\-009>L
and data looks like this: 1-205B or 2-113T. However, in
the drop down list in the combo box, the hyphen is
missing (1205B, 2113T) and this may confuse some users.
So, I plugged in the same input mask for the combo box
and the hyphen still doesn't show in the drop down list
of values, but when a value is selected, the hyphen DOES
show in the field. This is cool, however, a whole new
problem arises. If the user decides to tab to the field
and type (instead of selecting with the mouse) a value,
the field autofills with the first value the begins with
the number typed, and the cursor is moved to the far
right so if the user wants a value other than the
autofilled one, he will have to backspace to the proper
spot and type in the rest of the value.

1. Can I get the hyphen to show in the drop down list?

2. How can I get the field to behave so that users can
type instead of select with the mouse? I've tried using
the ! in the imput mask, which is supposed to cause the
mask to fill in from right to left, but it doesn't work.
Any ideas?

Thanx,

Rip
 
Hey, all,

I have a combo box that lists the values from a field in
another table. The input mask of this field is 0\-009>L
and data looks like this: 1-205B or 2-113T. However, in
the drop down list in the combo box, the hyphen is
missing (1205B, 2113T) and this may confuse some users.
So, I plugged in the same input mask for the combo box
and the hyphen still doesn't show in the drop down list
of values, but when a value is selected, the hyphen DOES
show in the field. This is cool, however, a whole new
problem arises. If the user decides to tab to the field
and type (instead of selecting with the mouse) a value,
the field autofills with the first value the begins with
the number typed, and the cursor is moved to the far
right so if the user wants a value other than the
autofilled one, he will have to backspace to the proper
spot and type in the rest of the value.

1. Can I get the hyphen to show in the drop down list?

2. How can I get the field to behave so that users can
type instead of select with the mouse? I've tried using
the ! in the imput mask, which is supposed to cause the
mask to fill in from right to left, but it doesn't work.
Any ideas?

Thanx,

Rip
Click to expand...

Your data is stored as 1250B because you haven't set the mask up to be
saved with the data. If you use the Input Mask wizard, the final page
of questions asks if you wish to save the mask with the data.
The mask should have a ;0; at the end, not ;;.

If ALL of the records have the hyphen in the second position, run an
update query to permanently change the stored data:

UpDate YoutTable Set YourTable.[FieldName] = Left([FieldName],1) & "-"
& Mid([FieldName],2)

Then change your Input Mask to save newly entered data with the mask.

Your Combo Box will then show the data as you want it.
 
Thank you so much, but I don't understand the syntax of
the update query. Could you maybe give me something to
type into the "update to:" box of the query in design
view? Thanx again, Rip

-----Original Message-----
Hey, all,

I have a combo box that lists the values from a field in
another table. The input mask of this field is 0\- 009>L
and data looks like this: 1-205B or 2-113T. However, in
the drop down list in the combo box, the hyphen is
missing (1205B, 2113T) and this may confuse some users.
So, I plugged in the same input mask for the combo box
and the hyphen still doesn't show in the drop down list
of values, but when a value is selected, the hyphen DOES
show in the field. This is cool, however, a whole new
problem arises. If the user decides to tab to the field
and type (instead of selecting with the mouse) a value,
the field autofills with the first value the begins with
the number typed, and the cursor is moved to the far
right so if the user wants a value other than the
autofilled one, he will have to backspace to the proper
spot and type in the rest of the value.

1. Can I get the hyphen to show in the drop down list?

2. How can I get the field to behave so that users can
type instead of select with the mouse? I've tried using
the ! in the imput mask, which is supposed to cause the
mask to fill in from right to left, but it doesn't work.
Any ideas?

Thanx,

Rip
Click to expand...

Your data is stored as 1250B because you haven't set the mask up to be
saved with the data. If you use the Input Mask wizard, the final page
of questions asks if you wish to save the mask with the data.
The mask should have a ;0; at the end, not ;;.

If ALL of the records have the hyphen in the second position, run an
update query to permanently change the stored data:

UpDate YoutTable Set YourTable.[FieldName] = Left ([FieldName],1) & "-"
& Mid([FieldName],2)

Then change your Input Mask to save newly entered data with the mask.

Your Combo Box will then show the data as you want it.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Thank you so much, but I don't understand the syntax of
the update query. Could you maybe give me something to
type into the "update to:" box of the query in design
view? Thanx again, Rip
-----Original Message-----
Hey, all,

I have a combo box that lists the values from a field in
another table. The input mask of this field is 0\- 009>L
and data looks like this: 1-205B or 2-113T. However, in
the drop down list in the combo box, the hyphen is
missing (1205B, 2113T) and this may confuse some users.
So, I plugged in the same input mask for the combo box
and the hyphen still doesn't show in the drop down list
of values, but when a value is selected, the hyphen DOES
show in the field. This is cool, however, a whole new
problem arises. If the user decides to tab to the field
and type (instead of selecting with the mouse) a value,
the field autofills with the first value the begins with
the number typed, and the cursor is moved to the far
right so if the user wants a value other than the
autofilled one, he will have to backspace to the proper
spot and type in the rest of the value.

1. Can I get the hyphen to show in the drop down list?

2. How can I get the field to behave so that users can
type instead of select with the mouse? I've tried using
the ! in the imput mask, which is supposed to cause the
mask to fill in from right to left, but it doesn't work.
Any ideas?

Thanx,

Rip
Click to expand...

Your data is stored as 1250B because you haven't set the mask up to be
saved with the data. If you use the Input Mask wizard, the final page
of questions asks if you wish to save the mask with the data.
The mask should have a ;0; at the end, not ;;.

If ALL of the records have the hyphen in the second position, run an
update query to permanently change the stored data:

UpDate YoutTable Set YourTable.[FieldName] = Left ([FieldName],1) & "-"
& Mid([FieldName],2)

Then change your Input Mask to save newly entered data with the mask.

Your Combo Box will then show the data as you want it.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

Make a backup of your table first...
type into the "update to:" box of the query <
Click to expand...

Left([FieldName],1) & "-" & Mid([FieldName],2)
 
It worked. Thanx a million!

Rip
-----Original Message-----
Thank you so much, but I don't understand the syntax of
the update query. Could you maybe give me something to
type into the "update to:" box of the query in design
view? Thanx again, Rip
-----Original Message-----
On Sat, 21 Aug 2004 12:22:48 -0700, RipperT wrote:

Hey, all,

I have a combo box that lists the values from a
Click to expand...
field
in
another table. The input mask of this field is 0\- 009>L
and data looks like this: 1-205B or 2-113T. However, in
the drop down list in the combo box, the hyphen is
missing (1205B, 2113T) and this may confuse some users.
So, I plugged in the same input mask for the combo box
and the hyphen still doesn't show in the drop down list
of values, but when a value is selected, the hyphen DOES
show in the field. This is cool, however, a whole new
problem arises. If the user decides to tab to the field
and type (instead of selecting with the mouse) a value,
the field autofills with the first value the begins with
the number typed, and the cursor is moved to the far
right so if the user wants a value other than the
autofilled one, he will have to backspace to the proper
spot and type in the rest of the value.

1. Can I get the hyphen to show in the drop down list?

2. How can I get the field to behave so that users can
type instead of select with the mouse? I've tried using
the ! in the imput mask, which is supposed to cause the
mask to fill in from right to left, but it doesn't work.
Any ideas?

Thanx,

Rip

Your data is stored as 1250B because you haven't set
Click to expand...
the
mask up to be
saved with the data. If you use the Input Mask wizard, the final page
of questions asks if you wish to save the mask with
Click to expand...
the
data.
The mask should have a ;0; at the end, not ;;.

If ALL of the records have the hyphen in the second position, run an
update query to permanently change the stored data:

UpDate YoutTable Set YourTable.[FieldName] = Left ([FieldName],1) & "-"
& Mid([FieldName],2)

Then change your Input Mask to save newly entered data with the mask.

Your Combo Box will then show the data as you want it.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

Make a backup of your table first...
type into the "update to:" box of the query <
Click to expand...

Left([FieldName],1) & "-" & Mid([FieldName],2)

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
However, I am still not able to tab to the field in the
form and type in the value without backspacing. It does
work when entering the values in the table field (which
is also a combo box), but not in the form. Is there a way
to fix this?

Rip

-----Original Message-----
Thank you so much, but I don't understand the syntax of
the update query. Could you maybe give me something to
type into the "update to:" box of the query in design
view? Thanx again, Rip
-----Original Message-----
On Sat, 21 Aug 2004 12:22:48 -0700, RipperT wrote:

Hey, all,

I have a combo box that lists the values from a
Click to expand...
field
in
another table. The input mask of this field is 0\- 009>L
and data looks like this: 1-205B or 2-113T. However, in
the drop down list in the combo box, the hyphen is
missing (1205B, 2113T) and this may confuse some users.
So, I plugged in the same input mask for the combo box
and the hyphen still doesn't show in the drop down list
of values, but when a value is selected, the hyphen DOES
show in the field. This is cool, however, a whole new
problem arises. If the user decides to tab to the field
and type (instead of selecting with the mouse) a value,
the field autofills with the first value the begins with
the number typed, and the cursor is moved to the far
right so if the user wants a value other than the
autofilled one, he will have to backspace to the proper
spot and type in the rest of the value.

1. Can I get the hyphen to show in the drop down list?

2. How can I get the field to behave so that users can
type instead of select with the mouse? I've tried using
the ! in the imput mask, which is supposed to cause the
mask to fill in from right to left, but it doesn't work.
Any ideas?

Thanx,

Rip

Your data is stored as 1250B because you haven't set
Click to expand...
the
mask up to be
saved with the data. If you use the Input Mask wizard, the final page
of questions asks if you wish to save the mask with
Click to expand...
the
data.
The mask should have a ;0; at the end, not ;;.

If ALL of the records have the hyphen in the second position, run an
update query to permanently change the stored data:

UpDate YoutTable Set YourTable.[FieldName] = Left ([FieldName],1) & "-"
& Mid([FieldName],2)

Then change your Input Mask to save newly entered data with the mask.

Your Combo Box will then show the data as you want it.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

Make a backup of your table first...
type into the "update to:" box of the query <
Click to expand...

Left([FieldName],1) & "-" & Mid([FieldName],2)

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top