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