• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

Microsoft Access Continous forms formatting

I have a contious form (not a subform) and I want to format certain records in the form, color blanks etc. I don't want to use conditional formatng. There are about 80 fields in each record and 6 condtions per field. It runs VERY slow with CF. I have tried a VB module being called from the data query. It is great for calcs but when I turn a field red in 1 record it turns the field red in  that field in all records displayed.
sample.jpg
0
Barry_Park
Asked:
Barry_Park
1 Solution
 
Rey Obrero (Capricorn1)Commented:
0
 
clarkscottCommented:
I believe conditional formatting is the only method you desire on FORMS.  Reports are different for they have a ON FORMAT event per detail line that provides a means for your type of coloring.

Scott C
0
 
Barry_ParkAuthor Commented:
great job-hard question
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now