Blanks in Report Detail & Underlines (Access 2002 SR1)

Topic

New Reply

** 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]

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote