changing yes/no to small/large

J

Joly

Hello.
I am absolutely new to Access. In design view, how would I change the yes/no
data type to being small/large?
Thanks so much, in advance for your help.
 
J

John W. Vinson

Hello.
I am absolutely new to Access. In design view, how would I change the yes/no
data type to being small/large?
Thanks so much, in advance for your help.
Click to expand...

If (and you need to think carefully about this If) these are the only two
values you will EVER have (i.e. there will never, ever be a need for Medium or
X-Large!) then you can *store* Yes/No (actually stored as -1 for Yes, 0 for
No), but use a Format property on your form or report to *display* the value
as small or large. A Format property

"";"Small";"Large";""

will display Yes as "Small", No as Large.
 
J

Joly via AccessMonster.com

Oh, thank you so much, John. Will it bring up a selection box to select
either large or small?
 
J

John W. Vinson

Oh, thank you so much, John. Will it bring up a selection box to select
either large or small?
Click to expand...

Not by itself, no; but you can certainly put a Combo Box or Listbox or Option
Group control on the form bound to the field. I'd suggest a listbox control;
set its Row Source Type property to "List of Values", its Row Source to

0;"Small";-1;"Large"

Set the Column Count to 2, the Column Widths to

0";0.5"

and the Bound Column to 1. This will display Small and Large but actually
store 0 and -1 respectively.
 
J

Joly via AccessMonster.com

Hi, John.

So sorry for taking so long to reply. Thanks so much for your advice. You've
been a big help. I really need to learn this program from scratch, but
sometimes you just get thrown into things, and then it becomes very exciting
to conquer what it can all do. hehe.
 
Top