Use command button to populate subform Tab

[slagg7575]

Hi all,

I have a subform, called DATA, and on that subform is a bunch of tabs,
each with different fields on them. I have a tab called NUMBERS, with
fields that contain numbers as data type. What I need is a command
button to be clicked when a user is finished entering data, and any of
the feilds on tab that are not filled, for them to be filled with "NA".
Can this be done?

Thanks!

 

[Al Campagna]

Slagg,
No. The fields are defined as numeric, so "N/A" could not be "entered" in that field
without a Type Mismatch.
However, you can trick the fields by setting up this Format for each field... (use your
own dec places format)
#.0 ; -#.0 ; 0.0 ; "N/A"
This will cause a "N/A" to be "displayed" in the fields on your tab if they are Null,
but the table will still contain a Null value... not "N/A"

Or...
#.0 ; -#.0 ; "N/A" ; "N/A"
Would display a "N/A" if the field was Null or Zero.

 

[slagg7575]

Al,
Excellent! Thank You!

SLagg

Slagg,
No. The fields are defined as numeric, so "N/A" could not be "entered" in that field
without a Type Mismatch.
However, you can trick the fields by setting up this Format for each field... (use your
own dec places format)
#.0 ; -#.0 ; 0.0 ; "N/A"
This will cause a "N/A" to be "displayed" in the fields on your tab if they are Null,
but the table will still contain a Null value... not "N/A"

Or...
#.0 ; -#.0 ; "N/A" ; "N/A"
Would display a "N/A" if the field was Null or Zero.
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions