Prev: Set focus in a specific record within a subform
Next: custom lines on pivot charts
From: TheLee on 26 Apr 2010 15:58
Hello,
I'm new to access and have a question regarding the footer. I created a text
box and inserted a basic equation for the the total cost of the order, =Sum(
[UnitPrice]*[Quantity]), however it is not appearing on the form. The
visibility property on the footer is set to Yes.

Please let me know what I am missing -

Thanks -

From: John W. Vinson on 26 Apr 2010 16:24
On Mon, 26 Apr 2010 19:58:53 GMT, "TheLee" <u59624(a)uwe> wrote:

>Hello,
>I'm new to access and have a question regarding the footer. I created a text
>box and inserted a basic equation for the the total cost of the order, =Sum(
>[UnitPrice]*[Quantity]), however it is not appearing on the form. The
>visibility property on the footer is set to Yes.
>
>Please let me know what I am missing -
>
>Thanks -

This should work on the Form Footer, but will not work on a Page Footer.
--

John W. Vinson [MVP]
From: TheLee on 26 Apr 2010 16:43
I got it to work by using a Continuous Form. Is this feature available on the
other form types? Just curious because this type will work. I was using a
Datasheet Form.

Thanks -



John W. Vinson wrote:
>>Hello,
>>I'm new to access and have a question regarding the footer. I created a text
>[quoted text clipped - 5 lines]
>>
>>Thanks -
>
>This should work on the Form Footer, but will not work on a Page Footer.

From: John W. Vinson on 26 Apr 2010 18:18
On Mon, 26 Apr 2010 20:43:34 GMT, "TheLee" <u59624(a)uwe> wrote:

>I got it to work by using a Continuous Form. Is this feature available on the
>other form types? Just curious because this type will work. I was using a
>Datasheet Form.

That's one of the many limitations of Datasheets: no header, no footer. A
Single Form has both (but a total could be confusing since you'ld see only one
record).
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Set focus in a specific record within a subform
Next: custom lines on pivot charts