Help!!

[Guest]

I'm a new user of Access and have had no formal training, so I'm sure there is a simple solution to my problem. I have created a very simple database containing two tables. My form contains a subform based on one of the tables. When I open the form, one of the fields in my subform table doesn't show all the data in it due to the column width. What can I to do to to display the data in full? Ideally, I would like to be able to double click in that field and have some sort of box pop up displaying all the data in that particular field. Is this possible? Any other suggestions would be welcome!! (Nothing too complicated please!
Cheer
Lyn

 

[Nikos Yannacopoulos]

Lyn,

In your database window, under forms, you should be able to see the subform.
Open it in design view, and fix the column widths. Any change you make will
be acrried over to its appearence in the main form.

HTH,
Nikos

I'm a new user of Access and have had no formal training, so I'm sure

there is a simple solution to my problem. I have created a very simple
database containing two tables. My form contains a subform based on one of
the tables. When I open the form, one of the fields in my subform table
doesn't show all the data in it due to the column width. What can I to do
to to display the data in full? Ideally, I would like to be able to double
click in that field and have some sort of box pop up displaying all the data
in that particular field. Is this possible? Any other suggestions would
be welcome!! (Nothing too complicated please!)

 

[JohnWL]

But she posted a more interesting question than you answered. How to show
the data in a pop-up form? For example, the field may be a memo field, and
increasing the column width is simply impractical and useless. (I've often
wondered about the same possibility.) So how can a pop-up form be developed
to display just the data in the highlighted field of the sub-form?

 

[John Vinson]

I'm a new user of Access and have had no formal training, so I'm sure there is a simple solution to my problem. I have created a very simple database containing two tables. My form contains a subform based on one of the tables. When I open the form, one of the fields in my subform table doesn't show all the data in it due to the column width. What can I to do to to display the data in full? Ideally, I would like to be able to double click in that field and have some sort of box pop up displaying all the data in that particular field. Is this possible? Any other suggestions would be welcome!! (Nothing too complicated please!)
Cheers
Lyn

You can move the cursor into the textbox and type Shift-F2 to bring up
a "zoom" box - a bigger box superimposed on your form.

 

[Guest]

Thanks John. Shift+F2 does exactly what I want! (I knew it would be something simple! lol

----- John Vinson wrote: ----

On Thu, 22 Jan 2004 17:31:05 -0800, Ly

I'm a new user of Access and have had no formal training, so I'm sure there is a simple solution to my problem. I have created a very simple database containing two tables. My form contains a subform based on one of the tables. When I open the form, one of the fields in my subform table doesn't show all the data in it due to the column width. What can I to do to to display the data in full? Ideally, I would like to be able to double click in that field and have some sort of box pop up displaying all the data in that particular field. Is this possible? Any other suggestions would be welcome!! (Nothing too complicated please!
Cheer
Ly

You can move the cursor into the textbox and type Shift-F2 to bring u
a "zoom" box - a bigger box superimposed on your form.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=publi

 

[Guest]

I've just had another thought. Can I make the action of "Shift+F2" run from a command button on my form?
Thanks
Lyn
----- Lyn wrote: -----


Thanks John. Shift+F2 does exactly what I want! (I knew it would be something simple! lol )

----- John Vinson wrote: -----

I'm a new user of Access and have had no formal training, so I'm sure there is a simple solution to my problem. I have created a very simple database containing two tables. My form contains a subform based on one of the tables. When I open the form, one of the fields in my subform table doesn't show all the data in it due to the column width. What can I to do to to display the data in full? Ideally, I would like to be able to double click in that field and have some sort of box pop up displaying all the data in that particular field. Is this possible? Any other suggestions would be welcome!! (Nothing too complicated please!)
Cheers
Lyn

You can move the cursor into the textbox and type Shift-F2 to bring up
a "zoom" box - a bigger box superimposed on your form.

 

[JohnWL]

Not easily. The command button would have the focus instead of the textbox
you wanted to zoom in on, so it wouldn't open a zoom box for the desired
textbox. I experimented by building a macro that uses the SendKeys action to
send the keystrokes "+{F2}" (which is the code for Shift F2) and set that
macro to run in the On DblClick event of a textbox control. But double
clicking in the box just highlights the clicked on word of text as it
normally does. This is certainly a desirable action itself, so ...

Perhaps someone else out there has a better idea?

--
John Loewen
Loewen Computing Services

I've just had another thought. Can I make the action of "Shift+F2" run

from a command button on my form?

Thanks
Lyn
----- Lyn wrote: -----


Thanks John. Shift+F2 does exactly what I want! (I knew it

would be something simple! lol )

----- John Vinson wrote: -----

I'm sure there is a simple solution to my problem. I have created a very
simple database containing two tables. My form contains a subform based on
one of the tables. When I open the form, one of the fields in my subform
table doesn't show all the data in it due to the column width. What can I
to do to to display the data in full? Ideally, I would like to be able to
double click in that field and have some sort of box pop up displaying all
the data in that particular field. Is this possible? Any other
suggestions would be welcome!! (Nothing too complicated please!)