1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 2000 problems with setting a LeftMargin

Discussion in 'Business Applications' started by rck55, Feb 17, 2003.

Thread Status:
Not open for further replies.
  1. rck55

    rck55 Thread Starter

    Joined:
    Feb 17, 2003
    Messages:
    2
    In a former database I was working on I used the following code with no problems. It formatted my report properly. Now for some odd reason it doesn't work. I am sure I am experiencing a brain fart, but any help would be appreciated.

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

    Desc.LeftMargin = 0

    If L2 > 0 Then
    Desc.LeftMargin = 500
    End If

    If L3 > 0 Then
    Desc.LeftMargin = 1000
    End If
    On Error GoTo DetailFormatERR
    DetailFormatERR:
    Resume Next
    End Sub
     
  2. downwitchyobadself

    downwitchyobadself

    Joined:
    Oct 13, 2000
    Messages:
    941
    The correct property is .Left, not .LeftMargin.
     
  3. rck55

    rck55 Thread Starter

    Joined:
    Feb 17, 2003
    Messages:
    2
    I had skipped an earlier step and thats why it wasn't populating the variables. Once I figured that out I got the LeftMargin to work. Thanks for the help though.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/119368

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice