RE: Calculated Controls on Reports
- From: "chris1 via AccessMonster.com" <u29373@uwe>
- Date: Tue, 28 Nov 2006 21:22:14 GMT
Hi Duane,
Here is what is happening just to make things clear. I have a form that a
user inputs data that is linked to a table. I have a button on the form that
saves the form and then proceeds to open a report through the acViewPreview
mode. My calculated control's "=iif(...." displays an #Error however if I
change the view to acViewNormal and then run the code then the calculated
control works when it is printed from the command button: here is the code:
DoCmd.Save ObjectType:=acForm, ObjectType:=Me.Name
DoCmd.OpenReport ReportName:=strRptName, view:=acViewPreview (acViewNornal)
The form is open with the user inputs while the code runs through the VBA
code.
When I just open the report through the Reports section then the calculated
controls work. So now I know I have the correct syntax for my calculated
controls. Do you know what is happening while I try to solve the sitaution as
well. Thank you for all your help.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200611/1
.
- Prev by Date: RE: Sorting on Last Name
- Next by Date: Re: delete pages in a report with VBA
- Previous by thread: RE: Calender report conversion.
- Next by thread: RE: Calculated Controls on Reports
- Index(es):
