Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Blanks in Report Detail & Underlines (Access 2002 SR1)

    ** I have a report that prints a DATE and POSITION as a grouped item on th Header section.

    ** In the Detail, it prints the duties of that position.

    Q1: IF THERE is a record, then I combine a 'bullet character' with the field so it prints out like bullet items. If there is no details, how do I supress the bullet with the blank
    line that the Detail section displays.

    Q2: The DATE and POSITION are printed as separate fields because the Date field needs to be Underlined. I would rather combine the fields.

    Is there a code I can place that will underline the date section only and leave the Position Field regular:

    FIELD1: [DATE]&" "&[POSITION]

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Blanks in Report Detail & Underlines (Access 2002 SR1)

    To answer your second question first, if you want to underline one word and not the other, then you have to print them separately. There is no way to format part of a string.

    In the format event of the detail section, you can check to see if there is a value in duties and if not, you can cancel the printing ot the section for that record like this:

    Me.PrintSection False
    Me.MoveLayout = False
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Blanks in Report Detail & Underlines (Access 2002 SR1)

    Actually I figured out the first one. I always come up with the answer right after I post. This is what I did. I created a Query that combined a bullet character (using the charmap) with the text. So in the query, it shows the data with a bullet before it. Then in the report, I put YES in the 'Can shrink' field. So not it prints only if Data is presend AND it containes a bullet.

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    Dudley, Midlands, England
    Posts
    55
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Blanks in Report Detail & Underlines (Access 2002 SR1)

    Regarding your second question, what Charlotte says is perfectly true.

    However in this instance, if the date and position text is left-justified and you are formatting the date with a hard-coded format which has a fixed length (e.g. dd/mm/yyyy or mm/dd/yy), you could insert a horizontal line into the report in the exact position you require underneath the date to give the impression of underlining.

    Simon.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •