Data display help

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

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.

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...