Hi,
I have a table on sharepoint that is linked in Access. I have only just set this up and so far it appears to be working. My problem is that the format of the number fields in sharepoint are not the same as in Access. IE Instead of showing decimals, it shows commas and/or it puts in commas where there shouldn't be any. IE 1000.8 shows as 1,008. 34519 shows as 34,519.
I checked the sharepoint settings but don't see an option to fix this, or if it is even possible.
Thanks,
Leesha
Sharepoint linked table
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Sharepoint linked table
Me again, i just stumbled on this code and tried it and it seems to work, unless someone has a better alternative.
{
"$schema": "https://developer.microsoft.com/json-sc ... chema.json",
"elmType": "div",
"attributes": {
"class": "=if(@currentField > 0,'', '')"
},
"children": [
{
"elmType": "span",
"txtContent": "@currentField"
}
]
}
{
"$schema": "https://developer.microsoft.com/json-sc ... chema.json",
"elmType": "div",
"attributes": {
"class": "=if(@currentField > 0,'', '')"
},
"children": [
{
"elmType": "span",
"txtContent": "@currentField"
}
]
}
-
- StarLounger
- Posts: 81
- Joined: 22 Feb 2022, 09:04
Re: Sharepoint linked table
Using Access 2007.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
-
- 3StarLounger
- Posts: 308
- Joined: 24 Dec 2015, 16:41
Re: Sharepoint linked table
if you are using a form as the user interface, bound to that table...then the control property of the text field can be optioned for several different display formats for numbers
having said that - overall I have found sharepoint to be a difficult and limiting approach to use for tables. it is a better idea to use an Access back end file if at all possible
having said that - overall I have found sharepoint to be a difficult and limiting approach to use for tables. it is a better idea to use an Access back end file if at all possible