Combo box LimitToList property setting of No - I still get MS Access error...

[MLH]

Combo box LimitToList property setting of No does not
prevent the MS Access error "The text you enter must
match an entry in the list" from popping up. What makes
this bad is that the error is not a capturable error.

My list has 2 fields: [Reason] and [ReasonCode]. The
2nd column is the bound column.

Here's the RowSource property setting:
Select [Reason],[ReasonCode] From [tblReasons];

I want the user to select a reason from the list, of course.
But I DON'T want the user to see a MS Access error
pop up in an app I rollout in a runtime environment built
using Access 2.0 and the ADT (Access Developer's
Toolkit). Any way to avoid this?

[Rick Brandt]

"MLH" <CR**@NorthStat e.net> wrote in message
news:1g******** *************** *********@4ax.c om...

Combo box LimitToList property setting of No does not
prevent the MS Access error "The text you enter must
match an entry in the list" from popping up. What makes
this bad is that the error is not a capturable error.

My list has 2 fields: [Reason] and [ReasonCode]. The
2nd column is the bound column.
A ComboBox that displays one column while being bound to another is
automatically "LimitToLis t = True". If you attempt to change it you should get
an error telling you that the setting is not allowed.

Here's the RowSource property setting:
Select [Reason],[ReasonCode] From [tblReasons];

I want the user to select a reason from the list, of course.
But I DON'T want the user to see a MS Access error
pop up in an app I rollout in a runtime environment built
using Access 2.0 and the ADT (Access Developer's
Toolkit). Any way to avoid this?

Some of the built-in messages are a bit cryptic, but this one is perfectly
clear. Why do you want to replace it? If you just want to eliminate the
"Microsoft Access" in the error's title bar just give your app its own
application title and then that is what the error box will display instead.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[MLH]

Good suggestions, Rick. I'll have a go with them. My
workaround was a 1-liner on the KeyUp event...

Sub MyComboBox_KeyU p (KeyCode As Integer, Shift As Integer)
Me!MyComboBox = Null
End Sub

And I really didn't like it much at all. Thx.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx x

Combo box LimitToList property setting of No does not
prevent the MS Access error "The text you enter must
match an entry in the list" from popping up. What makes
this bad is that the error is not a capturable error.

My list has 2 fields: [Reason] and [ReasonCode]. The
2nd column is the bound column.

A ComboBox that displays one column while being bound to another is
automaticall y "LimitToLis t = True". If you attempt to change it you should get
an error telling you that the setting is not allowed.

Here's the RowSource property setting:
Select [Reason],[ReasonCode] From [tblReasons];

I want the user to select a reason from the list, of course.
But I DON'T want the user to see a MS Access error
pop up in an app I rollout in a runtime environment built
using Access 2.0 and the ADT (Access Developer's
Toolkit). Any way to avoid this?

Some of the built-in messages are a bit cryptic, but this one is perfectly
clear. Why do you want to replace it? If you just want to eliminate the
"Microsoft Access" in the error's title bar just give your app its own
application title and then that is what the error box will display instead.