• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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