QUOTE (doctor9 @ May 16 2012, 03:08 PM)
For something like this, I think I'd create some VBA code in the OnFormat event for the section where the Q1 textbox appears.
Something along the lines of:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.strAccountName = "Margin" Then
Me.txtQ1.Format = "%"
Me.txtQ1.Format = "0.00"
Hope this helps,
Thank you for the quick reply. I have used and modified the code, and it does appear to be working, however, I can not view the "dependent" formatting in Report view (Print preview only), like theDBguy mentioned... Is there any work around to this? The standard UI Conditional formatting menu in '10 has not changed, you can only specify B/U/I and shading. However, may there be more options if you do conditional formatting via VBA? I am not sure.. maybe you could offer some insight on that as well?
QUOTE (RJD @ May 16 2012, 03:16 PM)
Actually, you could do this in a textbox like this (without any VBA):
Thank you Joe, this also works, but is going to require me to create a duplicate text box. If I enter this formula as the control source for the Q1 text box, it indicates a circular reference. I would probably have to hide the original Q1 box, then create a duplicate that does this 'dependent' formatting.. Or am I missing something basic?
Thanks for the help everyone.