Help, I'm new at this, and I'm sure it's not difficult

[jennifer]

Hi, I'm trying to create a personalized label for a memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.


I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone help me?

Thank You!
Jennifer

 

[fredg]

Hi, I'm trying to create a personalized label for a memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone help me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"

 

[Ken Snell]

Use a textbox, not a label. Set the control source of the textbox to
=Trim[FirstName] & "'s Personal Story:"

 

[Jennifer]

Thank you very much, I got it to work. Now I'm wondering
how I do a similar thing in a query. I want the printout
of book titles & subtitles to look like this
Nutrition: A Primer
Basics of Nutrition

*NOT*
Nutrition: A Primer
Basics of Nutrition:

(I don't want the colon when there's no subtitle)
I have a sloppy work around for now which is:

Full Title: Trim([Title/Name] & [Subtitle/Name])

and I started each subtitle out with ": A Primer"

Thanks again. I have the Access 2000 Bible book, but I
can't find information on how to do this stuff. Is there
a website with a well organized FAQ section on Access?

-----Original Message-----

Hi, I'm trying to create a personalized label for a memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone help me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[Ken Snell]

Try this:

Full Title: Trim([Title/Name] & ([Subtitle/Name] + ":"))

With above you shouldn't need the ": A Primer" in each subtitle name.

--

Ken Snell
<MS ACCESS MVP>

Thank you very much, I got it to work. Now I'm wondering
how I do a similar thing in a query. I want the printout
of book titles & subtitles to look like this
Nutrition: A Primer
Basics of Nutrition

*NOT*
Nutrition: A Primer
Basics of Nutrition:

(I don't want the colon when there's no subtitle)
I have a sloppy work around for now which is:

Full Title: Trim([Title/Name] & [Subtitle/Name])

and I started each subtitle out with ": A Primer"

Thanks again. I have the Access 2000 Bible book, but I
can't find information on how to do this stuff. Is there
a website with a well organized FAQ section on Access?

-----Original Message-----

Hi, I'm trying to create a personalized label for a memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone help me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[Jennifer]

GOT IT! Thank You!

The actual fix was a variation of what you gave me:
Full Title: Trim([Title/Name] & (": "+[Subtitle/Name]))

Sure appreciate the help!

For future issues, do you have a suggestion for a better
place to find answers to these kinds of expression syntax
questions?

-----Original Message-----
Try this:

Full Title: Trim([Title/Name] & ([Subtitle/Name] + ":"))

With above you shouldn't need the ": A Primer" in each subtitle name.

--

Ken Snell
<MS ACCESS MVP>

Thank you very much, I got it to work. Now I'm wondering
how I do a similar thing in a query. I want the printout
of book titles & subtitles to look like this
Nutrition: A Primer
Basics of Nutrition

*NOT*
Nutrition: A Primer
Basics of Nutrition:

(I don't want the colon when there's no subtitle)
I have a sloppy work around for now which is:

Full Title: Trim([Title/Name] & [Subtitle/Name])

and I started each subtitle out with ": A Primer"

Thanks again. I have the Access 2000 Bible book, but I
can't find information on how to do this stuff. Is there
a website with a well organized FAQ section on Access?

-----Original Message-----
On Mon, 12 Jul 2004 17:35:12 -0700, jennifer wrote:

Hi, I'm trying to create a personalized label for a memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone

help
me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

.

 

[Jennifer]

Last question for tonight...

In a report, I have the fields set-up like this:
Book Title Library Reimbursement Price
Library Notes (memo)

I've set the "Book Title" and "Library Notes" field to
expanding and collapsing, but the "Library Notes" still
takes up a line even when empty. How do I "trim" the
field so that it doesn't even hold a place when there's
nothing there?

Thanks again, Jennifer

-----Original Message-----
Try this:

Full Title: Trim([Title/Name] & ([Subtitle/Name] + ":"))

With above you shouldn't need the ": A Primer" in each subtitle name.

--

Ken Snell
<MS ACCESS MVP>

Thank you very much, I got it to work. Now I'm wondering
how I do a similar thing in a query. I want the printout
of book titles & subtitles to look like this
Nutrition: A Primer
Basics of Nutrition

*NOT*
Nutrition: A Primer
Basics of Nutrition:

(I don't want the colon when there's no subtitle)
I have a sloppy work around for now which is:

Full Title: Trim([Title/Name] & [Subtitle/Name])

and I started each subtitle out with ": A Primer"

Thanks again. I have the Access 2000 Bible book, but I
can't find information on how to do this stuff. Is there
a website with a well organized FAQ section on Access?

-----Original Message-----
On Mon, 12 Jul 2004 17:35:12 -0700, jennifer wrote:

Hi, I'm trying to create a personalized label for a memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone

help
me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

.

 

[Ken Snell]

Be sure that there is no label attached to the Library Notes textbox. Set
the height of the textbox to 0. Set the Detail section to allow grow and
shrink.

--

Ken Snell
<MS ACCESS MVP>

Last question for tonight...

In a report, I have the fields set-up like this:
Book Title Library Reimbursement Price
Library Notes (memo)

I've set the "Book Title" and "Library Notes" field to
expanding and collapsing, but the "Library Notes" still
takes up a line even when empty. How do I "trim" the
field so that it doesn't even hold a place when there's
nothing there?

Thanks again, Jennifer

-----Original Message-----
Try this:

Full Title: Trim([Title/Name] & ([Subtitle/Name] + ":"))

With above you shouldn't need the ": A Primer" in each subtitle name.

--

Ken Snell
<MS ACCESS MVP>

Thank you very much, I got it to work. Now I'm wondering
how I do a similar thing in a query. I want the printout
of book titles & subtitles to look like this
Nutrition: A Primer
Basics of Nutrition

*NOT*
Nutrition: A Primer
Basics of Nutrition:

(I don't want the colon when there's no subtitle)
I have a sloppy work around for now which is:

Full Title: Trim([Title/Name] & [Subtitle/Name])

and I started each subtitle out with ": A Primer"

Thanks again. I have the Access 2000 Bible book, but I
can't find information on how to do this stuff. Is there
a website with a well organized FAQ section on Access?

-----Original Message-----
On Mon, 12 Jul 2004 17:35:12 -0700, jennifer wrote:

Hi, I'm trying to create a personalized label for a
memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone help
me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label
control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

.

 

[Ken Snell]

Books about ACCESS can contain this info, as do the Help files. But your
best source for these types of things is the newsgroup community. You can
use Google to search past newsgroup messages.

--

Ken Snell
<MS ACCESS MVP>

GOT IT! Thank You!

The actual fix was a variation of what you gave me:
Full Title: Trim([Title/Name] & (": "+[Subtitle/Name]))

Sure appreciate the help!

For future issues, do you have a suggestion for a better
place to find answers to these kinds of expression syntax
questions?

-----Original Message-----
Try this:

Full Title: Trim([Title/Name] & ([Subtitle/Name] + ":"))

With above you shouldn't need the ": A Primer" in each subtitle name.

--

Ken Snell
<MS ACCESS MVP>

Thank you very much, I got it to work. Now I'm wondering
how I do a similar thing in a query. I want the printout
of book titles & subtitles to look like this
Nutrition: A Primer
Basics of Nutrition

*NOT*
Nutrition: A Primer
Basics of Nutrition:

(I don't want the colon when there's no subtitle)
I have a sloppy work around for now which is:

Full Title: Trim([Title/Name] & [Subtitle/Name])

and I started each subtitle out with ": A Primer"

Thanks again. I have the Access 2000 Bible book, but I
can't find information on how to do this stuff. Is there
a website with a well organized FAQ section on Access?

-----Original Message-----
On Mon, 12 Jul 2004 17:35:12 -0700, jennifer wrote:

Hi, I'm trying to create a personalized label for a
memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone help
me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label
control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

.

 

[Kay]

Aha! Height set to "0". That was the key. Thank You!

-----Original Message-----
Be sure that there is no label attached to the Library Notes textbox. Set
the height of the textbox to 0. Set the Detail section to allow grow and
shrink.

--

Ken Snell
<MS ACCESS MVP>

Last question for tonight...

In a report, I have the fields set-up like this:
Book Title Library Reimbursement Price
Library Notes (memo)

I've set the "Book Title" and "Library Notes" field to
expanding and collapsing, but the "Library Notes" still
takes up a line even when empty. How do I "trim" the
field so that it doesn't even hold a place when there's
nothing there?

Thanks again, Jennifer

-----Original Message-----
Try this:

Full Title: Trim([Title/Name] & ([Subtitle/Name] + ":"))

With above you shouldn't need the ": A Primer" in each subtitle name.

--

Ken Snell
<MS ACCESS MVP>

Thank you very much, I got it to work. Now I'm wondering
how I do a similar thing in a query. I want the printout
of book titles & subtitles to look like this
Nutrition: A Primer
Basics of Nutrition

*NOT*
Nutrition: A Primer
Basics of Nutrition:

(I don't want the colon when there's no subtitle)
I have a sloppy work around for now which is:

Full Title: Trim([Title/Name] & [Subtitle/Name])

and I started each subtitle out with ": A Primer"

Thanks again. I have the Access 2000 Bible book, but I
can't find information on how to do this stuff. Is there
a website with a well organized FAQ section on Access?

-----Original Message-----
On Mon, 12 Jul 2004 17:35:12 -0700, jennifer wrote:

Hi, I'm trying to create a personalized label for a
memo
field in my report. It should look like this:

David's Personal Story:
His story goes here from the memo field.

I want the field label to work something like this,
Trim[First Name]& "'s Personal Story:"

But I don't know the syntax for this. Can anyone help
me?

Thank You!
Jennifer

Use an Unbound text control for the label (not a label
control).
Set it's control source to:
=Trim([First Name]) & "'s Personal Story:"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.



.

.