How do I append an "s" to a group header on a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
New to Access and have run into this problem. I am displaying a field as
the group header of a report, but needto make it plural. Thanks
 
Hi,
New to Access and have run into this problem. I am displaying a field as
the group header of a report, but needto make it plural. Thanks
Click to expand...

Use an unbound text control.
Set it's Control source to
=[ControlName] & "s"

which may create a problem as some words do not add 's' to make a
plural, i.e. sheep, goose, fox, wolf, Katz, Bush, etc.
 
Thanks for the reply fredg

I did try that but received an error saying "this control has a reference to
itself" ie circular reference. That's the part I do not understand.

Can you clear that up for me?

appreciate the help,
Ben

fredg said:
Hi,
New to Access and have run into this problem. I am displaying a field as
the group header of a report, but needto make it plural. Thanks
Click to expand...

Use an unbound text control.
Set it's Control source to
=[ControlName] & "s"

which may create a problem as some words do not add 's' to make a
plural, i.e. sheep, goose, fox, wolf, Katz, Bush, etc.
Click to expand...
 
Thanks for the reply fredg

I did try that but received an error saying "this control has a reference to
itself" ie circular reference. That's the part I do not understand.

Can you clear that up for me?

appreciate the help,
Ben

fredg said:
Hi,
New to Access and have run into this problem. I am displaying a field as
the group header of a report, but needto make it plural. Thanks
Click to expand...

Use an unbound text control.
Set it's Control source to
=[ControlName] & "s"

which may create a problem as some words do not add 's' to make a
plural, i.e. sheep, goose, fox, wolf, Katz, Bush, etc.
Click to expand...
Click to expand...

Can't help you unless you tell me exactly what the control name is and
exactly what the control source is.
 
I was finally able to figure it out. "If Name AutoCorrect is turned on,
changing the name of the control will automatically update the control’s
Control Source property. The circular reference error will still exist, so to
remove the error, edit the control’s Control Source property to reverse the
automatic update."

Thanks again for your help. I have been assigned to create an application in
Access and it's been decades since I've done any coding (back in the Cobal
years). I'm sure I will get stumped again before this is complete.

-Ben


fredg said:
Thanks for the reply fredg

I did try that but received an error saying "this control has a reference to
itself" ie circular reference. That's the part I do not understand.

Can you clear that up for me?

appreciate the help,
Ben

fredg said:
On Thu, 27 Jul 2006 12:34:02 -0700, Ben wrote:

Hi,
New to Access and have run into this problem. I am displaying a field as
the group header of a report, but needto make it plural. Thanks

Use an unbound text control.
Set it's Control source to
=[ControlName] & "s"

which may create a problem as some words do not add 's' to make a
plural, i.e. sheep, goose, fox, wolf, Katz, Bush, etc.
Click to expand...
Click to expand...

Can't help you unless you tell me exactly what the control name is and
exactly what the control source is.
Click to expand...
 
Back
Top