Put dot after numbers

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

Rick

I have a report that I am numbering the records that I
need help with. I am using =(1) with running sum to get
the report to look like this:

1 abc
2 def
3 ghi

I want to have a dot after the number to look like this:

1. abc
2. def
3. ghi

But if I do =(1)& "." all I get is 1. 1. 1. not 1. 2. 3.
etc.
any help here?

Thanks
Rick
 
I have a report that I am numbering the records that I
need help with. I am using =(1) with running sum to get
the report to look like this:

1 abc
2 def
3 ghi

I want to have a dot after the number to look like this:

1. abc
2. def
3. ghi

But if I do =(1)& "." all I get is 1. 1. 1. not 1. 2. 3.
etc.
any help here?

Thanks
Rick
Click to expand...

Set the control source to
=1
You don't need the parenthesis.

Set the Running Sum property to Over all
Name this control 'RecNum'
Make it Not Visible.

Add another unbound control.
Set it's control source to:
=[RecNum] & ". "
 
Rick said:
I have a report that I am numbering the records that I
need help with. I am using =(1) with running sum to get
the report to look like this:

1 abc
2 def
3 ghi

I want to have a dot after the number to look like this:

1. abc
2. def
3. ghi

But if I do =(1)& "." all I get is 1. 1. 1. not 1. 2. 3.
Click to expand...


Set the text box's Format property to 0\.
 
You can do that.
Let us assume you named the current text box "Num#"
You can now create a second text box and in the source you
put <=[Num#]& "."> without the "<" or ">"
Now you can hide the first box and put the second box
right on top of it.
Hope this helps.
Fons
 
Back
Top