Checkbox value on one form display as checkbox, another form display as text value 'Y' (1 Viewer)

dd*

New member
Local time
Today, 12:05
Joined
Nov 17, 2020
Messages
15
Im not sure which forum to post this in Tables or Forms.

In my table design I have a Field with data type set to Yes/ No.

I have 2 forms
The first form:
1. Details form
2. Summary form

1. The Details form
The field is a checkbox.
If the checkbox is ticked - in the table, the value is stored as a checkbox ticked.

2. The Summary form
On this form I would like to display the checkbox value as a textbox ie either Y or if N - leave blank.

When I add the field to the Summary form.
The results are, the field displays as a drop down list with the arrow on the right hand side of the column.

Im still in design phase, therefore I've setup 2 Summary forms.
1 form as a continuous form. The second form is a split form with a datasheet.
Note; the field value displays the same on either form ie displays as a drop down list.


Is there a way to display the field in one form as a checkbox.
And in another form display the same value in a textbox ie no drop down list

TIA
 
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:05
Joined
Oct 29, 2018
Messages
15,227
Hi. Welcome to AWF!

I'm not sure I understand what you're asking. Can you post some mockups or drawings of what you expect to get? Thanks.
 

dd*

New member
Local time
Today, 12:05
Joined
Nov 17, 2020
Messages
15
Thank you.

Mockups uploaded.

On the Details form, the field Checkbox 3 displays as a checkbox.

On the Summary form, the same field Checkbox 3 displays as a drop down list with value 'Y'

In the table, Checkbox 3 data type is Yes/No. The value stored is a ticked checkbox.
I created the field Checkbox 3 Y/N data type as text, to see the design layout results on the Summary form.
 

Attachments

  • Access2019 display checkbox value - 18112020.jpg
    Access2019 display checkbox value - 18112020.jpg
    79.7 KB · Views: 45
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:05
Joined
Oct 29, 2018
Messages
15,227
Thank you.

Mockups uploaded.

On the Details form, the field Checkbox 3 displays as a checkbox.

On the Summary form, the same field Checkbox 3 displays as a drop down list with value 'Y'

In the table, Checkbox 3 data type is Yes/No. The value stored is a ticked checkbox.
I created the field Checkbox 3 Y/N data type as text, to see the design layout results on the Summary form.
Hi. Thank you. Have you tried using a calculated column in your query to convert the check into text that you can display? For example:

YN: IIf([CheckboxField],"Y","N")
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 22:05
Joined
Feb 19, 2002
Messages
31,957
Open the subform in design view and change the control to be a checkbox rather than a combo. You will have to delete the control and readd it.
 

Users who are viewing this thread

Top Bottom