conditional highlighting of a combobox

[Laoballer]

I have a form that has tabular data displayed. The data are imported
by a user then displayed on this form if there are any data that is
not in the correct format for a particular column. The column that
has bad data have been converted to a combo box with value list as
drop downs. What I would like to do is highlight all the combo boxes
that have a value that isn't in the value list so that the user could
quickly identify which field needs to be changed. Is this possible in
vba + access?

Thanks

 

[strive4peace]

you can do this with Conditional Formatting.

Expression is -->
[controlname]<>nz([controlname].[column](0))

turn the background a different color as text will not show unless
LimitToList is set to No


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Laoballer]

you can do this with Conditional Formatting.

Expression is -->
[controlname]<>nz([controlname].[column](0))

turn the background a different color as text will not show unless
LimitToList is set to No

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP..com/strive4peace

  *
    have an awesome day
  *

Laoballerwrote:

I have a form that has tabular data displayed.  The data are imported
by a user then displayed on this form if there are any data that is
not in the correct format for a particular column.  The column that
has bad data have been converted to a combo box with value list as
drop downs.  What I would like to do is highlight all the combo boxes
that have a value that isn't in the value list so that the user could
quickly identify which field needs to be changed.  Is this possible in
vba + access?

Thanks

Thanks for the tip, I think I got what I'm looking for.

 

[strive4peace]

you're welcome happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

you can do this with Conditional Formatting.

Expression is -->
[controlname]<>nz([controlname].[column](0))

turn the background a different color as text will not show unless
LimitToList is set to No

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Accesshttp://www.AccessMVP.com/strive4peace

*
have an awesome day
*

Laoballerwrote:

I have a form that has tabular data displayed. The data are imported
by a user then displayed on this form if there are any data that is
not in the correct format for a particular column. The column that
has bad data have been converted to a combo box with value list as
drop downs. What I would like to do is highlight all the combo boxes
that have a value that isn't in the value list so that the user could
quickly identify which field needs to be changed. Is this possible in
vba + access?
Thanks

Thanks for the tip, I think I got what I'm looking for.