Web Access Form not allowing negative entries in a currency field

[smudger70uk]

Hi, hoping someone can explain this one for.

I have developed and published a Web Access Database to SharePoint and it has been in use for 2 or 3 months without any issues until today when someone needed to enter a negative value in an invoice currency field to reflect a credit note and it doesn't accept this as a valid entry.

There are no issues entering a negative value in the database itself so it must be a SharePoint issue but it simply doens't make any sense. :banghead:

I'm either missing something that is so obvious I can't see it or there is a very basic issue with Web Access and sharePoint compatability.

Any pointers gratefully received, thx.

 

[AccessJunkie]

Hi,

This seems very odd indeed.

Are you using Office 365 to host this Access Services web database or are you using an on-prem SharePoint server within your own organization?

Just to clarify, if you open the web table in Access, you can enter a negative value, but if you use the web form displayed within the browser, you cannot enter a negative value?

Let me know the answers to those questions and then I'll see if I can repro the issue.

Thanks,

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
Senior SDET - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2013 Inside Out
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010/2013 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------