Yes/No Display

  • Thread starter Thread starter T''Kai
  • Start date Start date
T

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.
 
You can change the format control to yes/no. Right click on the listbox to
get properties and check 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.
 
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)?
 
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
 
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?

John Spencer said:
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 said:
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)?
Click to expand...
Click to expand...
 
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
'====================================================


T''Kai said:
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?

John Spencer said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.

John Spencer said:
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
'====================================================


T''Kai said:
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?

John Spencer said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top