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

M

Meg

Can someone help me please!

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a NaN in a field that is not a number field 1
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
ASK Field Formatting 1
Access form continuous 1
How to use/create code in MS Word to calculate age? 0
Autonumber field in Excel that behaves the same as Access 0
Claculating Percentages in InfoPath 2003 - NaN Erors 2
Format change in merge data - Bold formatting after a comma 0

Top