View Single Post
  #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.