How to put a )

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Hi,
I have a report that I want each line to be numbered, so
I added a text box with the following in the control
source I put =(1) and in the running sum I have it set to
over group. This works to number each line like this.
1
2
3
What I want is to put either a . or ) after each number
is there a way to do this in that text box or do I need
to add another text box? So it looks like this.
1.
2.
3.

Thanks
Rick
 
Just add another text box to your report, set its control
source to

=[txtLineNo] & "."

where txtLineNo is the name of your first text box.
You can then set your first text boxes visible property to
false.

hth

Chris
 
Thank you, works great
Rick
-----Original Message-----
Just add another text box to your report, set its control
source to

=[txtLineNo] & "."

where txtLineNo is the name of your first text box.
You can then set your first text boxes visible property to
false.

hth

Chris


-----Original Message-----
Hi,
I have a report that I want each line to be numbered, so
I added a text box with the following in the control
source I put =(1) and in the running sum I have it set to
over group. This works to number each line like this.
1
2
3
What I want is to put either a . or ) after each number
is there a way to do this in that text box or do I need
to add another text box? So it looks like this.
1.
2.
3.

Thanks
Rick
.
Click to expand...
.
Click to expand...
 
I have a report that I want each line to be numbered, so
I added a text box with the following in the control
source I put =(1) and in the running sum I have it set to
over group. This works to number each line like this.
1
2
3
What I want is to put either a . or ) after each number
is there a way to do this in that text box or do I need
to add another text box? So it looks like this.
1.
2.
3.
Click to expand...

Set the "Format" property for the textbox to "#." (without the quote marks).
 
Back
Top