Yes/No Field appears as Text Box

[Guest]

I'm creating a form with multiple fields. There are a number of Yes/No
fields, Text boxes and combo-boxes.
Dragging the firlds from the field list was working fine until I tried one
particular Yes/No field. It appears as a text box when I drag it across.
Properties list it as a Text Box with a format of "Yes/No".
In the table its a yes/no like many of the other fields. All the other
yes/no fields work fine, its just this one.
Any ideas.
p.s. Yes i have removed it, saved and re-opened and re-added. No luck

 

[SusanV]

Hi Dredd,
Yeah, annoying that it does that. Useful isn't it? From the toolbar, add a
checkbox control, then set it's source to your Yes/No field.

 

[Guest]

Thanks Susan. Any idea why that happens? Its a very annoying quirk.

 

[SusanV]

No, but I've had it happen a bunch of times. As annoying as it is, I've
never felt the need to dig into the why of it, I just get around it.

Perhaps one of the MVPs can clue us in?

SusanV

 

[Guest]

Can someone tell me how this is done? Are you referring to the Toolbox?

Thanks

 

[Douglas J Steele]

Open the table in Design mode, select the misbehaving boolean field then
look at the field properties at the bottom of the page. There should be 2
tabs: General and Lookup. Go to the Lookup tab: make sure the Display
Control property is set to Check Box.

Check Box should be the default, but it's possible it got changed somehow.

 

[SusanV]

Good morning Doug,

Thanks for that tip - however, I'm still confused on how this happens to
occasional Boolean fields? I'm talking about newly created fields, in new
form design, where the field was created as a Yes/No, not one that was
modified. Why does it want to show on the form as a textbox? As far as I can
see, the field creation in the table design is identical to other Boolean
fields which drag happily as a checkbox control.

Not a big deal, just curious...

TIA,

SusanV

 

[Douglas J Steele]

I'm not really sure what causes it.

I had thought that a possibility is that you added the field not as a
boolean, went on to create another field, then went back and changed the
type to boolean. However, when I tested just now, the field was changed to
CheckBox when I changed the type to Yes/No, even when I'd saved the table
first.

 

[SusanV]

Weirdness... no big deal - I've only had it happen a couple of times! Thanks
for the response,

SusanV