Question Linked table in access - display control changng on Yes/No (1 Viewer)

[mrbg07546]

Hi All

have a access 2007 file. with a table with a yes/no field. When I link the table to another db using lnked table manager, the yes/no display is not a checkbox(as set) but is turns into textbox. any idea why this is happening?

knd regards

 

[David R]

YesNo checkboxes are problematic anyway. http://allenbrowne.com/noyesno.html

You can format any field that accepts -1/0 as input into a checkbox on your forms and reports.