Recent content by GretchenCh

  1. G

    Nesting Iif statement with Mid and InStr Functions

    After some more testing I noticed that the above issues go away when I use rich text vs plain text, but the hanging indent also goes away. Also, when I use rich text, the shorter lines (<45 len) are indented at the beginning of the line.
  2. G

    Nesting Iif statement with Mid and InStr Functions

    In Access 2010, I am using the following to add a hanging indent to the detail section of a 3 column report. =IIf(Len([KeyArrRpt])<=45,[KeyArrRpt],Left([KeyArrRpt],InStr(45,[KeyArrRpt]," ")) & Chr(13) & Chr(10) & " " & Mid([KeyArrRpt],InStr(45,[KeyArrRpt]," ")+1)) I get the...
  3. G

    Hi

    Mountain Home is a nice area. What part of NV do you live in? I lived in NV for about 7 years and still go back frequently to visit family.
  4. G

    Hi

    Hi, I live in Idaho and work for a print music/musical accessories dealer. I've been working in Access off and on for almost ten years now, but haven't got a lot of experience in the VBA and SQL sides of things. This forum has been my go-to forum for getting hard-to-find answers. I look forward...
See more
Back
Top Bottom