add numeric number to a control

H

help

Hi, I have a list of child names. Child1 Name, Child2
Name, etc. I would like to add "1. 2., etc. to the Child
Names. So it looks like ex. 1. Jen Smith. I can't figure
out how to do this..any help would be
appreciated....thanks!
 
D

Duane Hookom

You should be able to use expressions like:
="1. " & [Child1 Name]
Make sure the name of the text box is not the name of a field. If you are
concerned about a number displaying with no child name then use:
="1. " + [Child1 Name]

BTW: This structure is a bit un-normalized...
 
H

help

thanks that worked...the name of the box was the same
name.
-----Original Message-----
You should be able to use expressions like:
="1. " & [Child1 Name]
Make sure the name of the text box is not the name of a field. If you are
concerned about a number displaying with no child name then use:
="1. " + [Child1 Name]

BTW: This structure is a bit un-normalized...

--
Duane Hookom
MS Access MVP


Hi, I have a list of child names. Child1 Name, Child2
Name, etc. I would like to add "1. 2., etc. to the Child
Names. So it looks like ex. 1. Jen Smith. I can't figure
out how to do this..any help would be
appreciated....thanks!


.
 
Top