How to resize Data Form dialog window?

[Compucat]

On a friend's computer today, I created a small "database" (list of names/addresses) with a header row (in Excel 2002). I wanted to show her the Data/Form feature for quick entry. The "Sheet 1" dialog window opened as usual and I entered a couple of records for demonstration and then closed the Form. What would have triggered the following situation, I do not know, but the next time I clicked Data/Form, the dialog window completely filled the screen. Only by dragging the window by placing the cursor arrow in the top border did the right side contents of the window come into view (the buttons for New/Restore/Prev/etc.). Although the window had the usual large X at the top-right corner to close it, I could not otherwise reduce the size of this window. The practicality of using the Data/Form was essentially made neglible since the entry fields were out of view to the left if the buttons were in view, and visa versa.

On my Excel 2003 (note, a newer version) at home, I have tried to recreate the above situation to no avail.

What to do to restore the Data/Form quick entry window to a reasonable size?

Thank you.

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson

[Dave Peterson]

I think when I used xl2002 and win98, I could open excel and then change the
settings of the display (windows start button|settings|control panel|display
applet) and excel would have to be restarted for it to notice the change in
settings. (So some of the data|form dialog could be off the screen.)

But with xl2003 and winXP, excel noticed the windows setting change when I
closed the data|form dialog and reopened the data|form dialog.

Were you playing with the windows setting?





Compucat wrote:
>
> On a friend's computer today, I created a small "database" (list of
> names/addresses) with a header row (in Excel 2002). I wanted to show
> her the Data/Form feature for quick entry. The "Sheet 1" dialog window
> opened as usual and I entered a couple of records for demonstration and
> then closed the Form. What would have triggered the following
> situation, I do not know, but the next time I clicked Data/Form, *the
> dialog window completely filled the screen*. Only by dragging the
> window by placing the cursor arrow in the top border did the right side
> contents of the window come into view (the buttons for
> New/Restore/Prev/etc.). Although the window had the usual large X at
> the top-right corner to close it, I could not otherwise reduce the size
> of this window. The practicality of using the Data/Form was essentially
> made neglible since the entry fields were out of view to the left if the
> buttons were in view, and visa versa.
>
> On my Excel 2003 (note, a newer version) at home, I have tried to
> recreate the above situation to no avail.
>
> What to do to restore the Data/Form quick entry window to a reasonable
> size?
>
> Thank you.
>
> --
> Compucat
> ------------------------------------------------------------------------
> Compucat's Profile: http://www.excelforum.com/member.php...o&userid=24129
> View this thread: http://www.excelforum.com/showthread...hreadid=377507

--

Dave Peterson