Put dot after numbers

[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

 

[fredg]

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

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] & ". "

 

[Marshall Barton]

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.

Set the text box's Format property to 0\.

 

[Fons Ponsioen]

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

 

[Guest]

Thank you this way was simple and just what I was looking
for.
Thanks again,
Rick