Yes/No column weird behavior via Terminal Server

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

karl dewey

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Encrypt column? 2
Cannot run function from autoexec macro 10
Yes/no column in listbox 1
Printing a query parameter 2
Any way to recover a deleted module? 3
Display custom toolbar when open query? 2
Docmd.OutputTo messages 1
Transfertext from ftp server with userid/password 1

Top