Problems with forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 02 Feb 2008 03:27 GMT

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

Signature

Ron

Reply to this Message

John W. Vinson - 02 Feb 2008 05:31 GMT

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

Reply to this Message

Ron - 03 Feb 2008 02:42 GMT

Signature

Ron

> >I am having two problems with forms:
> >
[quoted text clipped - 12 lines]
> 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.

> > 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
[quoted text clipped - 7 lines]
>
> 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.

Reply to this Message