View Single Post
  #7  
Old May 14th, 2010, 07:35 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Conditionally Format A Line?

You must be in the code/module/vba window, not in the properties dialog.
There should not be any "=", just:
Me.[Line18].[Visible]=([Me].[txtIPG]="RESALE")

--
Duane Hookom
Microsoft Access MVP


"1stAyd via AccessMonster.com" wrote:

Still no luck. I created txtIPG, with the control source as [Inventory
Posting Group], and have this in the "On Format" event of the detail section:

=[Me].[Line18].[Visible]=([Me].[txtIPG]="RESALE")

I'm sure the answer will be something really simple.... TIA.


1stAyd wrote:
I tried that too, but didn't realize [Inventory Posting Group] had to be tied
to a report control.....


--
Message posted via http://www.accessmonster.com

.