Getting a NaN in a field that is not a number field

[Meg]

I have 2 fields in a form - PartnerStatus and ActivityType - both are
supposed to be alpha fields and they are both dropdown list boxes. When I
open the form to fill out, both have a Numeric 0 already in them and when I
try to select from the dropdown box it puts in a NaN in the box. My data is
in Access and no where in there do I have a 0 in it and it is not coded as a
numberic field.

I did run a Tools, Logic Inspector on the form and it does have listed under
"Calculated Default Values" the 2 following:
@ActivityType: sum(@ActivityType)
@PartnerStatus: sum(@PartnerStatus)

I cannot figure out where I can delete these 2 calculations out.

Any help would greatly be appreciated.

Thanks,

MEG

 

[Shiva (GGK Tech)]

Hello,

Those calculations are default value for those fields. You will get those
calculation by using the below steps,
1. Open form in design mode.
2. Select View -> Data Sources.
3. Go to your dropdown field and double click on that field to open
properties window.
4. Check once ‘Default Value’ and remove that existing calculation on that
field.
5. Click on OK button.