I have a counter in a memofield
there count characters
is there a way where i can say
if characters = 30 then make a newline??

Hi.
i have created a form in Access and have set up combo boxes. However when i
go to create a new record it copies the selection in the combo box to the new
record, whe i change this it alters the first record as well. is there

On my form I have a subform which is created as "Continuous Forms". The form
is used to track comp time earned at work. I have two fields that collect the
data which are "Hours Earned" + Hours Used"
At the bottom of the form I would like to create three fileds

Is there a way in a text box where i can say that user only can write
maby 25 lines ?
regards
alvin

WIN XP OFFICE XP
Hello.
My office has upgarded from WIN 98 Office 2000 to XP ver of both. The
problem that I am facing is that some of tricks do not work anymore.Like:

This:
=sum(nz([InvoiceCost],0))
generates a syntax error when put in as a control source for an unbound
textbox in the footer of a subform, whereas:

Is there a way to make a event only
on the enter button
Regards
alvin

I am looking how to view tag property of active control with help of
unbound text box.
My idea was to bound Control Source of text box to
Form.ActiveControl.Tag or something like this.

I have a form where users can select to view the report based on criteria in
the form. At times, of course, there is no item that meets the criteria and
when the report is previewed, it shows a blank form with the various headers.
How do I go about putting a dialog box that will ...

I currently have a user form that utilizes a hyperlink allowing the user to
view pdf files that are relevant to the current database record they are
viewing.  Is there anyway to have the PDF file open in a subform for direct
viewing in access rather than having the Adobe viewer ...

Hi!!
I have thsi code from Dirk goldgar there
in a variable have the numbers of lines ina memofield
Now i want to show the numbers of lines in a textbox or label

I have a main form "Projects" and a subform "WorkOrders".
When I add a new project I need for (3) WorkOrders to be created
automatically.
The WorkOrders subform has a record "WorkOrderType" that queries a table

hey all,
i have a form with a button on it that opens my report in preview mode. Is
there a way to open with 100% Zoomed and and certain window size/or
maximized? Right now, by default it opens in Fit view and the window it too

This is crazy...the properties dialog box is there in form view, but it's
invisible...everything else loses focus and the 'help' is listed at the
bottom that indicates I have an active cursor inside the properties sheet.  I
just can't see the properties sheet. Yet for reports it ...

I need to be able to detect if a subform is currently displaying a vertical
scrollbar.
I think a call to the API is the way to go - but as yet I cannot get this to
work