Unbound Textbox calculation not showing a result

[cyberwolf0000 via AccessMonster.com]

I have 3 bound controls txtBW_Ver with a control source of BW_Ver, txtOE_Ver
with a control source of OE_Ver & txtTW_Ver with a control source of TW_Ver.

I have an unbound text box with a control source of

=[txtBW_Ver]+[txtOE_Ver]+[txtTW_Ver]

The unbound box is not showing the calculation at all. I have also tried
using the source fields

=[BW_Ver]+[OE_Ver]+[TW_Ver]

This also did not produce a result. I have checked the controls source field
types, they are all set to number as a Long Integer. I have made sure the
field is always visible and that the font color is black.

Can anyone tell me why this simple calculation is not working?

TIA

--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2

 

[cyberwolf0000 via AccessMonster.com]

I have 3 bound controls txtBW_Ver with a control source of BW_Ver, txtOE_Ver
with a control source of OE_Ver & txtTW_Ver with a control source of TW_Ver.

I have an unbound text box with a control source of

=[txtBW_Ver]+[txtOE_Ver]+[txtTW_Ver]

The unbound box is not showing the calculation at all. I have also tried
using the source fields

=[BW_Ver]+[OE_Ver]+[TW_Ver]

This also did not produce a result. I have checked the controls source field
types, they are all set to number as a Long Integer. I have made sure the
field is always visible and that the font color is black.

Can anyone tell me why this simple calculation is not working?

TIA

Never mind, I figured it out. I had to use Nz around each field name. This
information was imported from a FileMaker Pro database and the blank field
must not have actually been null but empty.

Thanks anyway

--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2