Problems with forms

[Ron]

I am having two problems with forms:

1. All of my forms go the full window. There are no
borders on my forms! I am setup with Single View, as I want and all of the
properties are as they should be.

2. I have three tables that have multiple Yes/No boxes
on them as defined in the setup of the tables Each box Lookup in the table is
set to be a checkbox. But when I put one of these fields on the form and
right click on the text box and go to Change To the checkBox Option is grayed
out.

Can Anyone Help??
TIA

 

[John W. Vinson]

I am having two problems with forms:

1. All of my forms go the full window. There are no
borders on my forms! I am setup with Single View, as I want and all of the
properties are as they should be.

If you maximize any form or other object, everything gets maximized. You can
put a Macro with just one line

Restore

in each form's Open event, or equivalently an Event Procedure with one line:

Private Sub Form_Open(Cancel as Integer)
DoCmd.Restore
End Sub

2. I have three tables that have multiple Yes/No boxes
on them as defined in the setup of the tables Each box Lookup in the table is
set to be a checkbox. But when I put one of these fields on the form and
right click on the text box and go to Change To the checkBox Option is grayed
out.

Change the Lookup property to textbox (to display the actual contents of the
table, -1 for True or 0 for False); and just use the toolbox wizard to add a
checkbox on the form, and set its control source to the fieldname.

John W. Vinson [MVP]

 

[Ron]

--
Ron

If you maximize any form or other object, everything gets maximized. You can
put a Macro with just one line

Restore

in each form's Open event, or equivalently an Event Procedure with one line:

Private Sub Form_Open(Cancel as Integer)
DoCmd.Restore
End Sub

DoCmd.Restore had no effect in the Open event of 8 forms. I have some older
DB's and BEs for Access2007 where the datasheet size is adjustable. It
appears that the frontends is where the problems come in. this is a real
hassle.

Change the Lookup property to textbox (to display the actual contents of the
table, -1 for True or 0 for False); and just use the toolbox wizard to add a
checkbox on the form, and set its control source to the fieldname.

John W. Vinson [MVP]

The same thing, here I have DBs where I can change to a check box from the
right click menu and others where I can't. It just upsets me that an
application would change in a matter of weeks while I am using it and remove
some functionality that no one knows about the removal and no one get told.