Help change Control to Show page # rather then Tick Box WorkinLady 11/27/2008 3:57:01 PM I’m not sure how to put this question without confusing myself lol I am working on a database at work and one of the managers had come to me with this problem that I thought I could resolve. They had created a form that is connected to a report and wanted it so if the mailing address was incorrect that you would check off the tick box and when the report opened with this information, rather then a Tick in the tick box it could appear on the report as a page number in the footer. So that customers don’t question the Tick on the report all they would only see a page number. And when are team saw the page number they would know that we need to correct the address.

RE: Help change Control to Show page # rather then Tick Box Clifford Bass 11/29/2008 2:25:04 AM Hi WorkinLady, Try this, which assumes that there is one address per report page. If there are more than one it will not make any sense. Create a text box in the footer. Set its Source Control to =IIf([BadAddress],[Page],Null) where BadAddress is the Yes/No column that indicates there is a bad address. Clifford Bass "WorkinLady" wrote: [Quoted Text] > I’m not sure how to put this question without confusing myself lol > I am working on a database at work and one of the managers had come to me > with this problem that I thought I could resolve. > They had created a form that is connected to a report and wanted it so if > the mailing address was incorrect that you would check off the tick box and > when the report opened with this information, rather then a Tick in the tick > box it could appear on the report as a page number in the footer. So that > customers don’t question the Tick on the report all they would only see a > page number. And when are team saw the page number they would know that we > need to correct the address. >

Re: Help change Control to Show page # rather then Tick Box "Slavisa Madelic" <madelic.slavisa[ at ]comhem.se> 12/12/2008 9:22:16 PM "WorkinLady" <WorkinLady[ at ]discussions.microsoft.com> wrote in message news:20096D49-ECA1-4EFD-B586-00B702C9699F[ at ]microsoft.com... [Quoted Text] > I’m not sure how to put this question without confusing myself lol > I am working on a database at work and one of the managers had come to me > with this problem that I thought I could resolve. > They had created a form that is connected to a report and wanted it so if > the mailing address was incorrect that you would check off the tick box > and > when the report opened with this information, rather then a Tick in the > tick > box it could appear on the report as a page number in the footer. So that > customers don’t question the Tick on the report all they would only see a > page number. And when are team saw the page number they would know that we > need to correct the address. > >