Re: Yes/No Display

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" wrote:

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

"Golfinray" wrote:

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

"T''Kai" wrote:

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" wrote:

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

"T''Kai" wrote:

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.

.

Relevant Pages

  • Re: Yes/No Display
    ... John and Golfinray, ... You can use the format function in the query that is the source for the list box. ... After you modify the source you should then see Yes or No in the listbox for ...
    (microsoft.public.access.gettingstarted)
  • MSProject
    ... Could I ask a favour and ask if you could update this to a new format of msproject? ... You could look at saving as an Excel file from Project 95 and then opening ... Project MVP ... I also received a reply from John, ...
    (microsoft.public.project)
  • Re: time calculation problem
    ... The formula worked in minutes as john mentioned. ... So now i want a Al's format and Johns accuracy. ... Place a text control on your form with a ControlSource of... ...
    (microsoft.public.access.gettingstarted)
  • Re: Installed Hard Disk In Dell Vista Machine Today
    ... Perform A Quick Format Tells Windows Vista to format without ... mark bad sectors on the disk and lock them out. ... Then john would have lied when he claimed the book was his source ... See how reality works yet snit? ...
    (comp.sys.mac.advocacy)
  • Fill
    ... Fill format doesn't work on shapes created by user ... Fill is based on individual Geometry sections within the ShapeSheet. ... I did my little experiments in Visio 2003. ... John Marshall, MVP wrote: ...
    (microsoft.public.visio.general)