Data display help

[Grifter]

Hi

I have a linked table to sharepoint in Access, which is divided up by a filter for SP sites, the data of which is sourced from a table in a SQL DB. In my SP I have a field set initially to Y/N but this showed a tick box, which I did not want, then as I realised I only need to show Y/N/' ' I changed the SP type back to single line of text but it now shows 1 or 0 now (Y or N equivalent), I have tried updating the data from Access link, which despite being a text field it is showing tick boxes in Access - why i do not know and it still remains as 1 or 0.

Any help would be much appreciated.

G

[dmaruca]

access creates the tabledefs locally and they are cached in the database. refresh the tables in your linked table manager (database tools tab) and the update should propagate.

[nO_OnE]

The data is still stored as a 1 or a 0, just because it is displayed as a check box in access does not mean it is storing a check, it is just how the data is being displayed...