We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

What is the syntax to reference Access report fields in VBA

JayceW
JayceW asked
on
Medium Priority
655 Views
Last Modified: 2013-11-28
I am trying to call an Access report field from a Macro but can't seem to get the syntax correct in my VBA script. I have enclosed a copy of my code. This may look a little muddled as I have tried several attempts to get it to work.

Hopefully from the code it should be quite obvious what I am trying to do, update the rag report output to appropriate colours so that I can then export the file. (which conditional formatting doesn't allow.


DoCmd.openreport "rpt90", acViewPreview
 
Dim rpt90 As Report_rpt90
 
If rpt90!RAG_Label = "A" Then
Rrpt90.RAG_Label.Properties("ForeColor") = vbYellow
ElseIf Reports!rpt90.TextBox("R/A/G") = "R" Then
Reports!rpt90.TextBox("R/A/G").ForeColor = vbRed
ElseIf UCase(Reports!rpt90.TextBox("R/A/G")) = "G" Then
Reports!rpt90.TextBox("R/A/G").TextBox.ForeColor = vbGreen
End If
 
End Sub

Open in new window

Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Excellent thanks, Next step I will find out how to loop through the rows on my report to apply the formatting.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
JayceW,

I think mbizup has most of this covered, but, ...
What is this line supposed to ber doing?:
    Dim rpt90 As Report_rpt90

AFAICT (Unless you have some special Library loaded), your code will error out right away at this line, with a "User defined type, not defined" error.

Perhaps it should be:
    Dim rpt90 As Report

?

JeffCoachman

Author

Commented:
Thanks Jeff, that line, as you suggest was not needed, so I have already removed it from the code
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.