Al Akers
Last Activity: Nov 24 '10, 05:24 AM
Joined: Nov 20 '10
Location:
-
So simple. I did not have VBA content enabled. I have not used access since Access 97 was out. Now I see results and debug is talking to me. Thanks for your suggestions. -Al. -
Still no change. Good idea to put tracers in the Event. I did change the names of my Report fields (Property Sheet/Other/Name) to be different from the table field names in case there was confusion. I modified my On Format Event to say:
...Code:Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.OLEimage.Left = 1440 ' one inch in TWIPS Me.LastName.Left = 1440 ' Debug.Print "Me.OLEimage.Left: "
Leave a comment:
-
I’m also a bit new to participating in lists as a questioner. Thanks. –Al.Leave a comment:
-
How to move image on report using Detail OnFormat Event?
I have a problem of changing the placement of an embedded image for a report/print. The initial left measurement of the image format is set to 0. I desire to move the image to the right during a Detail section On Format Event.
Starting with a simple command to move the embedded OLE field 1 inch to the right I have set up a Detail On Format Event of:
...Code:Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Last edited by MMcCarthy; Nov 25 '10, 06:29 PM. -
Me.Detail.Visible=False does not suppress Detail
Being new to Access 2007, I am Trying to solve a bigger report problem, so I start simple with a Detail On Format Event of:
The report detail is visable for all records! When this works I will build up to my desired filtering, but this simple event proceedure failes to suppress the detail area of my report....Code:Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Detail.Visible = False End Sub
No activity results to display
Leave a comment: