calculated fields not showing

[Jake]

When I try and use a field on a form that is a calculated value the value is
not calculated until the controll has focus.

It is only affecting controlls bound to calculated values(those startign
with "=", so:
this works
- Controll Source: [fieldname]
this doesn't
- Controll Source: =[fieldname]

When the problem occurs the value displays only when the controll gains the
focus but thereafter it stays regardless of focus.

Jacob

 

[Arvin Meyer [MVP]]

You should not be binding (or saving) calculated values. Do the calculation
in the form:

ControlSource:

= ControlName1 + ControlName2

and don't try to save the results.

 

[Jake]

That is exactly what I am doing. Any ControllSorce that is calculated (i.e.
one that begins with an "=" such as in the example you gave) is not
displaying at runtime until the controll becomes active.

I am not atempting to save anything, just to display it.

Jacob

You should not be binding (or saving) calculated values. Do the calculation
in the form:

ControlSource:

= ControlName1 + ControlName2

and don't try to save the results.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

When I try and use a field on a form that is a calculated value the value
is
not calculated until the controll has focus.

It is only affecting controlls bound to calculated values(those startign
with "=", so:
this works
- Controll Source: [fieldname]
this doesn't
- Controll Source: =[fieldname]

When the problem occurs the value displays only when the controll gains
the
focus but thereafter it stays regardless of focus.

Jacob

 

[Arvin Meyer [MVP]]

That's not the case for either single form view or datasheet on my forms.
Perhaps Access is confused by a name, try:

= [ControlName1] + [ControlName2]
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

That is exactly what I am doing. Any ControllSorce that is calculated
(i.e.
one that begins with an "=" such as in the example you gave) is not
displaying at runtime until the controll becomes active.

I am not atempting to save anything, just to display it.

Jacob

You should not be binding (or saving) calculated values. Do the
calculation
in the form:

ControlSource:

= ControlName1 + ControlName2

and don't try to save the results.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

When I try and use a field on a form that is a calculated value the
value
is
not calculated until the controll has focus.

It is only affecting controlls bound to calculated values(those
startign
with "=", so:
this works
- Controll Source: [fieldname]
this doesn't
- Controll Source: =[fieldname]

When the problem occurs the value displays only when the controll gains
the
focus but thereafter it stays regardless of focus.

Jacob