A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Controlling text fields in access 2002



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 08:50 AM posted to microsoft.public.access
Gasket
external usenet poster
 
Posts: 2
Default Controlling text fields in access 2002

I'm having some problems making my data input form nicely usable. First of
all I'd like the text field to grow bigger when written on it, instead of
scrolling as it does now. Is it possible to make the active field grow on top
the others and then go back to it's defined size when another field is
activated? I have a lot of fields in my form and I can't enlarge them
anymore. And the fields might contain a lot of text or none at all.

Another thing is that when printed, the totally empty fields could be left
out completely. Now all I can do is minimize them and print the title and an
empty box with the height of one line. I would only like print the fields and
titles that actually contain information.

One more thing is organizing my reports. Now I have a counter giving each
report a number and organizing those based on that number. The problem is
that people make empty reports, or fill in a previous empty report somewhere
in between newer and older reports. This screws up my filing because the
latest reports might have an old index. I have an idea to make a manditory
"date"-field so that one couldn't exit the report without filling in the
date. Then I could organize the reports by date. I'm not good with VB, so how
can I make the exit-button to check if the date has been entered?

I'd be very grateful for any help you could provide.
  #2  
Old June 1st, 2010, 11:15 AM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Controlling text fields in access 2002

While the cursor is in a text box, hitting the key combination Shift-F2 will
cause a Zoom box to pop up.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"Gasket" wrote in message
...
I'm having some problems making my data input form nicely usable. First of
all I'd like the text field to grow bigger when written on it, instead of
scrolling as it does now. Is it possible to make the active field grow on
top
the others and then go back to it's defined size when another field is
activated? I have a lot of fields in my form and I can't enlarge them
anymore. And the fields might contain a lot of text or none at all.

Another thing is that when printed, the totally empty fields could be left
out completely. Now all I can do is minimize them and print the title and
an
empty box with the height of one line. I would only like print the fields
and
titles that actually contain information.

One more thing is organizing my reports. Now I have a counter giving each
report a number and organizing those based on that number. The problem is
that people make empty reports, or fill in a previous empty report
somewhere
in between newer and older reports. This screws up my filing because the
latest reports might have an old index. I have an idea to make a manditory
"date"-field so that one couldn't exit the report without filling in the
date. Then I could organize the reports by date. I'm not good with VB, so
how
can I make the exit-button to check if the date has been entered?

I'd be very grateful for any help you could provide.



  #3  
Old June 1st, 2010, 11:34 AM posted to microsoft.public.access
Gasket
external usenet poster
 
Posts: 2
Default Controlling text fields in access 2002

I think I might have solved the third problem, at least partially. I can make
the date needed by modifying the options of the data type from the structure
table. Only problem is that I can't change the option, because not all old
reports have dates. I guess I have to manually either delete the dateless
reports or add dates to them, before I can make the date compulsory and start
sorting the reports by date.

I still have no idea how to solve the first two problems, or will my sorting
idea even work.
  #4  
Old June 2nd, 2010, 10:29 PM posted to microsoft.public.access
Peter Hibbs
external usenet poster
 
Posts: 871
Default Controlling text fields in access 2002

You could easily just change the Height parameter of the Text box
control when it gets the focus and then change it back when it loses
the focus. Something like this :-


Dim vHeight As Long

Private Sub YourTextBox_GotFocus()
vHeight = Me.YourTextBox.Height
Me.YourTextBox.Height = 1500
End Sub

Private Sub YourTextBox_LostFocus()
Me.YourTextBox.Height = vHeight
End Sub


where YourTextBox is the name of your text box control. Change the
figure 1500 (Twips) to the value you need for your box when it has the
focus. If you know the height of the Text box control then you could
just use that figure in place of the vHeight variable which would not
then be needed.

Peter Hibbs.


On Tue, 1 Jun 2010 00:50:01 -0700, Gasket
wrote:

I'm having some problems making my data input form nicely usable. First of
all I'd like the text field to grow bigger when written on it, instead of
scrolling as it does now. Is it possible to make the active field grow on top
the others and then go back to it's defined size when another field is
activated? I have a lot of fields in my form and I can't enlarge them
anymore. And the fields might contain a lot of text or none at all.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.