Yes/No column weird behavior via Terminal Server

  • Thread starter Thread starter Dorian
  • Start date Start date
D

Dorian

I have a listbox that shows the contents of a Yes/No column. When I work in
the office, it displays Yes or No for the contents. However, when I access
the database remotely via Terminal Server, the columns display as 0 or -1.
Does anyone know if there is a way around this?
Thanks.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Boolean data, Yes/No, is stored as -1 and 0. Either set your display format
for Yes/No or use an IIF statement.
IIF([YourField] = -1, "Yes", "No")
 
Back
Top