Checkbox value on one form display as checkbox, another form display as text value 'Y'

[dd*]

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

 

[theDBguy]

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*]

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.

 

[theDBguy]

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]

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.