Yes/No Display

[T''Kai]

Hello Everyone,

I have several yes/no fields in a table and I am displaying them in a listbox.

One user on the network sees the words yes and no. All other users see -1
and 0. The table shows -1 and 0. All desktops are configured the same (at
least I think so). I have looked and cannot see a significant difference.

My question is why is this one user seeing yes and no.

Thank you all very much.

 

[Golfinray]

You can change the format control to yes/no. Right click on the listbox to
get properties and check format.

 

[T''Kai]

Thank you for your response Golfinray. I looked but I cannot see a format
control for the listbox. Also, there are other users that have the same
interface(mde) and they see -1 and 0 not yes and no.

Any other suggestions.

 

[Golfinray]

One of the properties of the listbox (right click, properties) should say
format.

 

[T''Kai]

I checked again. There is a tab that says "Format", however, there is no
property under this tab that control the actual format of the data in the
listbox. I checked under the "All" tab and again there is no property that I
see that has a yes/no display value.

Could it be the version of Access I am using (2003)?

 

[John Spencer]

There is no property to format the individual columns in a listbox control.

You can use the format function in the query that is the source for the list box.

Field: MyCheckBox: Format([MyCheckboxField],"Yes/no")

After you modify the source you should then see Yes or No in the listbox for
the column.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[T''Kai]

Thank you John. I know I can do this. However, I was trying to understand why
different users using the exactly same interface (seperate mde on each
computer) sees different things. Only 1 user sees yes and no the others see
-1 and 0. What is so dfferent about this one user?

There is no property to format the individual columns in a listbox control.

You can use the format function in the query that is the source for the list box.

Field: MyCheckBox: Format([MyCheckboxField],"Yes/no")

After you modify the source you should then see Yes or No in the listbox for
the column.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I checked again. There is a tab that says "Format", however, there is no
property under this tab that control the actual format of the data in the
listbox. I checked under the "All" tab and again there is no property that I
see that has a yes/no display value.

Could it be the version of Access I am using (2003)?

 

[John Spencer]

Asuming that they are all using a copy of the same mde, I can't think of
any reason for the behavior to vary.

Sorry

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Thank you John. I know I can do this. However, I was trying to understand why
different users using the exactly same interface (seperate mde on each
computer) sees different things. Only 1 user sees yes and no the others see
-1 and 0. What is so dfferent about this one user?

There is no property to format the individual columns in a listbox control.

You can use the format function in the query that is the source for the list box.

Field: MyCheckBox: Format([MyCheckboxField],"Yes/no")

After you modify the source you should then see Yes or No in the listbox for
the column.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I checked again. There is a tab that says "Format", however, there is no
property under this tab that control the actual format of the data in the
listbox. I checked under the "All" tab and again there is no property that I
see that has a yes/no display value.

Could it be the version of Access I am using (2003)?

:

One of the properties of the listbox (right click, properties) should say
format.

:

Thank you for your response Golfinray. I looked but I cannot see a format
control for the listbox. Also, there are other users that have the same
interface(mde) and they see -1 and 0 not yes and no.

Any other suggestions.

:

You can change the format control to yes/no. Right click on the listbox to
get properties and check format.

:

Hello Everyone,

I have several yes/no fields in a table and I am displaying them in a listbox.

One user on the network sees the words yes and no. All other users see -1
and 0. The table shows -1 and 0. All desktops are configured the same (at
least I think so). I have looked and cannot see a significant difference.

My question is why is this one user seeing yes and no.

Thank you all very much.

 

[T''Kai]

John and Golfinray,

Thank you for your help. I will continue to explore this problem. If I find
out what is causing this behavior I will let you and the group know.

Thanks Again.

Asuming that they are all using a copy of the same mde, I can't think of
any reason for the behavior to vary.

Sorry

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Thank you John. I know I can do this. However, I was trying to understand why
different users using the exactly same interface (seperate mde on each
computer) sees different things. Only 1 user sees yes and no the others see
-1 and 0. What is so dfferent about this one user?

There is no property to format the individual columns in a listbox control.

You can use the format function in the query that is the source for the list box.

Field: MyCheckBox: Format([MyCheckboxField],"Yes/no")

After you modify the source you should then see Yes or No in the listbox for
the column.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

T''Kai wrote:
I checked again. There is a tab that says "Format", however, there is no
property under this tab that control the actual format of the data in the
listbox. I checked under the "All" tab and again there is no property that I
see that has a yes/no display value.

Could it be the version of Access I am using (2003)?

:

One of the properties of the listbox (right click, properties) should say
format.

:

Thank you for your response Golfinray. I looked but I cannot see a format
control for the listbox. Also, there are other users that have the same
interface(mde) and they see -1 and 0 not yes and no.

Any other suggestions.

:

You can change the format control to yes/no. Right click on the listbox to
get properties and check format.

:

Hello Everyone,

I have several yes/no fields in a table and I am displaying them in a listbox.

One user on the network sees the words yes and no. All other users see -1
and 0. The table shows -1 and 0. All desktops are configured the same (at
least I think so). I have looked and cannot see a significant difference.

My question is why is this one user seeing yes and no.

Thank you all very much.