Is it possible to use the "Filter By Form" function to search for data within
subform fields? I have not had any success using this function.
I created three tables. tblmarkets, tblcontacts and tblcontactdetails. I
created a one-to-many relationship between these three tables. ...

I have a field build in a form called comments that I want to be able to type
into. I have looked at the Northwinds database and formatted my comments
field to the same specs as in the Employees Notes field. I hear a beep when I
try to type into the Comments field in my form. Any ...

I have a table called "Events".  I also have a Form called "Events".  I would
like to create another form that will filter EventDates.  It was three Combo
Boxes Month, Day, year.  I have a text box that will put all these values
together in a date format (Example: =[Combo19] & ...

what I would like to do is selectively hide or make invisible certain
controls on a continuous form, i.e on one detail line the control would be
visible but not visible on another detail line (dependant on the value of
another permanently visible control. I am talking here about ...

I have a lookup box on a Form that when you expand the list you can see
there first name and surname, but after selecting it only displays there
first name.  Where i want it to display the whole name
how can i do this??

My users want to use multiple text formatting in a comment field.  For
example,  they need to use bold, italics and regular text in this field.
Any suggestions are appreciated.
Thanks!

In working with Access 2003, I want to disallow the scrolling of a memo
field, which happens automatically if you type beyond the last line.  
Limiting the # of lines would do as well.  Of course, either the # to use,
whether lines or characters, would depend upon the font, but ...

I've experimented and searched this newsgroup but I still don't have
the answer to this basic question. Although it should be simple I'll
try to explain it thoroughly in the hope others will find this answer.
If I have a textbox on my form which has a vba function as

What are the names of the vbColors I can use to set text color?
I know  vbBlue, vbRed, vbBlack, vbGreen...any othres?

I have a text box whose original label has been deleted. I want to associate
a new label to it. The HELP says: create the new label, CUT the new label,
click on the text box, paste. Does not work.
Tried it with check boxes etc.

Up to Dec 31, 2005 I could insert "todays date " in a field with keystrokes
"CTRL+Semicolon", when year changed to 2006 it does not work now.
Does anybody have an answer to this problem

I want to be able to add a File Open control to an Access 2003 form
which, IIRC, I could do in Access 97.  When I try to add the Microsoft
Common Dialog Control 6.0 to a form I get an error that says I'm not
licensed to use it.  I'd rather not use an API call if possible.  Is there

I would  like to know how can I obtain a result of HOURS:MINUTES for the
total of all records in a form, where each record has two fields in the
format of "dd/mmm/yyyy/hh:nn AM/PM", one for "aircraft take off" the other
"aircraft landing".  Each record on the form represents a ...

How should i disable replace function in form. I want users to use find only
but not replace.

How do I NOT have a form display an ID #, but rather show it's actual
value.
For example, if I have two tables:
tblPeople