Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / October 2005

Tip: Looking for answers? Try searching our database.

NaN error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NikV - 24 Oct 2005 14:51 GMT
I am reading data from an XML file that was generated from a MS database.  I
am populating that data into a text field.  There could be data and sometimes
there could be no data.

When there is no data, the text box shows a NaN with a red dash line around
the text box.  This is preventing the form from saving the data back to the
DB.  Is there a way around this so that I can save the data back to the DB
even though there is no data?

Thanks for your help!
Franck Dauché - 24 Oct 2005 15:06 GMT
Hi,

What data type is the field that gives you trouble in your schema in IP?

Franck Dauché

> I am reading data from an XML file that was generated from a MS database.  I
> am populating that data into a text field.  There could be data and sometimes
[quoted text clipped - 6 lines]
>
> Thanks for your help!
NikV - 26 Oct 2005 14:25 GMT
The DataType that is in IP is simpleType, formatted to be currency.  The data
Type that I stored in the DB is numeric.  Does that answer your question?

> Hi,
>
[quoted text clipped - 12 lines]
> >
> > Thanks for your help!
Franck Dauché - 26 Oct 2005 16:45 GMT
Hi,

Can you default your textbox to 0?  It should get rid of the issue.

Regards,

Franck Dauché

> The DataType that is in IP is simpleType, formatted to be currency.  The data
> Type that I stored in the DB is numeric.  Does that answer your question?
[quoted text clipped - 15 lines]
> > >
> > > Thanks for your help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.