Yes/No Problems

[Dogberry]

Hi

I have four columns on a form that are designated Yes/No. Three of the columns have displayed the expected tick box. One however shows the word No. Properties for all four appear the same.

Has anyone any clues as to where I should be looking to change it to a tick box.

Many thanks

Dogberry

 

[isladogs]

In the table design, change the display control for that field from textbox to checkbox
It will then appear as a checkbox whatever type of form you use

However, if you don't want that behaviour globally, modify the form design adding a checkbox bound to that field in place of the existing textbox

 

[Dogberry]

Hi Ridders

Checked the Display Control for all four and they all show checkbox? on the table side its only when it comes to the form that one table shows No the other three tables added to the form all have the expected check box.

Thanks

Dogberry

 

[The_Doc_Man]

on the table side its only when it comes to the form that one table shows No the other three tables added to the form all have the expected check box.

Time to validate something. Are you actually pulling in contents from four TABLES to one form? If that is true, tell us some more about that fine point - like, how are the values getting there in the first place? Because a form's .RecordSource is essentially a named table or query or a literal query. The only way you can do this through form "standard" binding is with a four-table JOIN. Otherwise you are using something similar to the DLookup function. So tell us about this form's linkage to its data.

 

[Dogberry]

Hi Doc

I am very new to access so I have uploaded a pic of my situation. I am going into the Tbl to enter the correct ticks in the box. The Mrs goes into this form so she can view the information without altering it.

All the tick boxes from the forms have been added using add "existing fields" on the ribbon and as you can see columns 1 3 and 4 are ok its 2 that's the pain.

Can you keep the explanation simple so that someone simple like me can understand it

Thanks a lot

Dogberry

 

[isladogs]

In design view replace all the text boxes for the months with Checkboxes with each bound to a month Jan / Feb etc

However I agree with the Doc that using 4 tables is far more complicated than this ought to be. I thought you meant 4 fields originally

 

[The_Doc_Man]

From that picture and your claim that you are a novice, I'm going to suggest that the fields in your 2nd column are NOT check boxes. Their shape is wrong. They look like text boxes.

A checkbox is ALWAYS ALWAYS ALWAYS square even if you try to expand or reshape it. All it would do when you expand it is sit there like a lump. In essence, you CANNOT make a rectangular check box. For the record, expanding the size of the checkbox DOES increase the size of the "hot spot" for that check box, i.e. the size of the area you would click to set or clear the box.

I think you have to look very carefully at the properties of those controls. They ain't what you think they are.

 

[Dogberry]

Hi Doc

They are tick boxes in the table I have made the boxes bigger because when they were the proper size all I had was a hash.

From the picture I put up is what I am trying to achieve possible and if so am I using a nuke to crack a peanut or is their a simpler way and yes I am a novice access was purchased about 10 days ago. The Access Bible and Access for Dummies has been my guide so far with the help of you people.

By the way since found out that I cannot add, search etc with that form either

Thanks

Dogberry

 

[Dogberry]

I have uploaded a pic of the properties page for the table the lookup is checkbox, what else am I missing.

Thanks

Dogberry

 

[isladogs]

You are missing the point that both Doc & I are making.

The Month table may indeed use checkboxes but that's not how you are displaying them on the FORM

On the FORM shown in your first image all the boxes in column 2 are textboxes.
Those in columns 1,3 & 4 are checkboxes
Open the FORM in DESIGN view and change column 2 textboxes to checkboxes

 

[Dogberry]

Hi


if you are talking about right click change to label, list and combo are the only choices I have the rest are greyed out.

Unfortunately my database is over the limit or I would upload it

Thanks

Dogberry

 

[isladogs]

I'm talking about the textboxes containing Yes / No !!!!!!!!
i.e. the items I've highlighted in YELLOW
(plus those for remaining months not visible in your image)

AND I'm talking about REPLACING these with checkboxes

 

[JHB]

..
Unfortunately my database is over the limit or I would upload it
..

Have you done a "Compact & Repair" + zipped it?
You don't need to post the whole database, just the form and the needed tables to show some sample data.