a user types in a certain amount of text into a memo field
after certain length the text should have a vbCrLf just before the word that
is the one that causes the length problem
text should just continue on the next line rather than being wrapped (which

I want to handle Conditional Formatting in VBA.
I can see how to READ and WRITE backColor, foreColor and fontBold using
".FormatConditions"
I can see how to WRITE the logic condition (using ".Add"),

I'll try not to make this too long!  For this forms sake I'm dealing
with 5 tables (listed below).  I've looked at the Nwind and a whole
bunch of others, but mine doesn't work the way those do, so I'm
confused.

I have a form with a subform. In the on error property of the sub form I
have this code
Private Sub Form_Error(DataErr As Integer, Response As Integer)
   Dim strMsg As String

I'm using access2000. could anybody help me how to make the default
navigation buttons work in my form.
Currently I've developed a macro to open the form with focus on PK box
with a text of PK(integer) + 1 value.

i want to enable my user to open a form subject to the condition the value of
the "Patient Number" on it is equal to a value selected by the user on the
'Switchboard' form called 'Command and Control Center' via an unbound combox.
so i use this string in the OnOpen property

I need some help coming up with a table and the form coding to get something
accomplished.  I have a complete database which in all other aspects is
complete.  Take a look at this input screen:
http://www.mpscan.net/screen1.jpg

I am developing an Access 2000 app. I am trying to be a little fancy with
the forms and would like a background picture (watermarked) on one of my
subforms to make it look a little nicer.
When I try to add a picture to the subform using the "Picture" property of

I am wondering how to set column widths and visibility
options for form fields in datasheet view.
TIA, TimJ

When using the following code:
.......
   If Me.FrmRespondedOrNot = 2 Then
           strTest = Me.cbxOperators.Column(3)

I added the code to add data to a combo box if it does not already appear in
the list. However, I am getting the following error:
"The expression Not In List you entered as the event property setting
produced the following error: Procedure declaration does not match

MS Access 2000, Windows XP
======================
Hi,
I have a form to enter new record, and what I'd like to accomplish is that

    I have a problem that I realy dont understand with one of my forms for
the inventory. I use Access with SQL server, all my tables and stored procs
are on my SQL db. Since last week everything works great since I add a
checkbox on my form. My form as a unique table dbo.Inve ...

I have huge accsss 2003 database: approx 180Mm of code only. and i'm using
Source safe
The database is sql server and it is 800Mb
The import and export of objects are failed in some times. If i work on the

I am using an active x controller of the date picker in a form.
Is there a way that I can get the date selected then populate 7 textboxes to
show the week that was selected?