View Single Post
  #9  
Old May 14th, 2010, 09:41 PM posted to microsoft.public.access.reports
fredg
external usenet poster
 
Posts: 4,386
Default Conditionally Format A Line?

On Fri, 14 May 2010 17:41:06 GMT, 1stAyd via AccessMonster.com wrote:

Now I'm really confused. As an attempt to simplify, I put this line into "On
Format" of the "Detail" section:

=[Me].[Line18].[Visible]=True

but Line18 still isn't visible...... Thanks.


Not only do you appear to be confused but now I am as well grin

See Duane Hookums latest reply.
I suspect, as he does, that you are placing the code in the wrong
place.
Here is how to write code.
Click on the Event Tab of the report's Detail Section property sheet.
On the Format event line write:
[Event Procedure]
Click on the little button with 3 dots that appears on that line.
The Format event code window will appear.
The cursor will be flashing between 2 already existing lines of code.
Between those 2 lines write:

Line18.Visible = [Inventory Posting Group] = "RESALE"

Exit the window and save the VBA code.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail