In a single form how many words or letters can you put into a form.  I was
typing into a single form and I cannot put anymore words into it.  I have
about 197 letters in my form.  It is set for 255

I know this comes up a lot, but I’m still missing something…..
I have a button on a form that runs an append query to update a table.
There is subform that uses data from this table to create a list.  When I
click the button the append query works fine, but I cannot get the subform

I would like to make it so when my form loads it starts at new record, not
sure how to accomplish this. right now it starts at record 1.

I have a form with a field called “Department” that has the following
entries:  Real Estate, Corporate, Litigation.  I have another field called
“Sub Department” that has specialty areas of the departments.  
For example:

The Field is too small to accept the amount of data you attempted to add. Try
inserting or pasting less data.
My table has two fields. I am only working with the first field. Its a text
filed and it has less then 60 chcracters. Its fine in table mode but when I

Hi there, using A02 on XP. Not a programmer, but learning more and more. Luv
the newsgroups!
I have a report that needs to have a few financial fields updated from an
imported file. My users export a text file from specialty software and then

I exported a form to another database and want to use a table in that
database as the source for the fields in the form.  I can get a new form
created by a wizard to recognize the table in the new database, but for some
reason I cannot figure out how to get the form I imported to ...

Have been asked update & facelift an old Access db.
Is it possible to programtically to change all the fonts  in a forms
controls & labels?
Using Access 2002

I've seen Access applications in the past where forms have the appearance of
a group of stacked file folders.  Each tab at the top contains the name of
another form.  Does anyone know of a template or wizard I can use to create
this look?  Thanks.

I have a 9 table hierarchy  database, I am wanting to create a search form
with a Combo Box to search for a particular record (as put in the Text Box)
and then display the requested record in a different form.
I created the search form with a Text Box with a command button.  On ...

My user terminates the aplication by clicking a button on the main form's
screen.  In my onclick event for that button, and just before I actually
terminate the application by closing the main form, I display another little
form to confirm some ending status information with the ...

Access 2k Win98
What is the input Mask to change entries to  proper ( 1st letter capitals)
case in a name field in a form. Also is there an addin / macro /module which
would modify Name field in the table to proper case.

Hello.  I hope somebody can clear things up for me regarding this matter.  I
am trying to set up a database based on the inventory control template.  I
have read a fair few posts about combos but still dont fully understand what
to do.

I run a mcro on a 'on click' event from a button within a form  the code is
attached below. It is designed to transfer records from one table to another.
The message appears , so the if then statement is being executed.
Private Sub Command1_Click()

I use a "Multi-Select" Listbox to select multiple values (consecutive or
non-consecutive)... the selected values are then used as query criteria.
Please refer to function below:
*********************************