Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formatting and filter

Status
Not open for further replies.
GeoffreyB

GeoffreyB

Technical User
May 20, 2002
3
GB
I have a form that has conditional formatting on seven fields in the detail area. I filter the form using toggle buttons and VB Code to create a filter string using

Me.Filter = strCfilter
.....
......
Me.FilterOn = True

Depending on the number of conditional fields I can only run the filter a fixed number of times befopre getting the helpful message

"Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience."

MS Access 2002 SP-2 Running on Windows XP professional

Any suggestions gratefully received

Many thanks

GeoffreyB
 
Status
Not open for further replies.

Similar threads

rccline
  • Locked
  • Question
Highlighting Duplicates with Conditional Formatting 2
2
Replies
26
Views
2K
strongm
strongm
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
3K
JanaLNelson
JanaLNelson
DeRochier
  • Locked
  • Question
Conditional formatting on Yes/No fields
Replies
2
Views
443
Axworthy
Axworthy
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top