calculated fields not showing

  • Thread starter Thread starter Jake
  • Start date Start date
J

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
 
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.
 
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

Arvin Meyer said:
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

Jake said:
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
Click to expand...
Click to expand...
 
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

Jake said:
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

Arvin Meyer said:
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

Jake said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top