Formatting a text field in report

L

laurenm

Hi All,

Is there a way to change the formatting in a report text field based on the
field meeting certain criteria? For example, if my text field has the date
format of "mm" & "/" & "dd" & "/" & "yyyy", then apply a bold format. I
looked into the conditional formatting but it didn't work for me. Maybe I am
setting it up incorrectly. If anyone knows how to do this (if it can be done)
please let me know.

Thanks,
LaurenM
 
B

Beth Melton

My first question is why you are storing a date as a Text data type
and not a Date/Time data type. Or is this a concatenated string?

Perhaps if you told us more about what you are trying to do exactly we
might be able to help.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
L

laurenm

Hi Beth,

It is a text field because in this report, my fields are based on a query
results where I created a format expression that gives me a specific format
not available in the default date/time format. If changing the field to a
date/time format will matter to help me bold the results, I can change it to
a date/time field and stick with an Access default. Please advise.

What I am trying to do is display a project schedule where my results
consist of projected dates of completion and actual completion dates (if
there is a completed date to a task, I show the completed date, not the
original projected date). In order to visually tell which dates are completed
and which are projected I use a different format for each kind of date. The
projected dates I show as a mm/dd/yy format and the completed dates show as
mm/dd/yyyy format. I would like to bold the completed dates so it is even
easier to distiguish between the two types of dates. Can someone give any
insight as to how to do this (if it is even possible).

Thanks!
LaurenM
 
B

Beth Melton

laurenm said:
Hi Beth,

It is a text field because in this report, my fields are based on a
query
results where I created a format expression that gives me a specific
format
not available in the default date/time format. If changing the field
to a
date/time format will matter to help me bold the results, I can
change it to
a date/time field and stick with an Access default. Please advise.
Click to expand...

The built-in formats, such as Short Date, are based on your Regional
Settings in your Control Panel.

If you want to use a specific format then just type it in the format
property: mm/dd/yyyy
What I am trying to do is display a project schedule where my
results
consist of projected dates of completion and actual completion dates
(if
there is a completed date to a task, I show the completed date, not
the
original projected date). In order to visually tell which dates are
completed
and which are projected I use a different format for each kind of
date. The
projected dates I show as a mm/dd/yy format and the completed dates
show as
mm/dd/yyyy format. I would like to bold the completed dates so it is
even
easier to distiguish between the two types of dates. Can someone
give any
insight as to how to do this (if it is even possible).
Click to expand...

You should have this separated in two fields, one for completion and
one for projected. Or, if your projected completion date is based on a
calculation of another date, such as start date, then use a calculated
field instead.

Then in your query for the field on your report use something like:

ReportDate: Nz([CompletionDate],[ProjectedDate])

Then just use a Conditional format for the ReportDate text box using
an Expression such as: [CompletionDate] Is Null

Also note there are newsgroups dedicated to Access. If you have any
future questions you'll likely find faster responses by posting to one
of the Access newsgroups. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
L

laurenm

Thanks, Beth. I will give this a try.

I would love to go to an Access-specific Newsgroup but when I go the the
Newsgroups area from the Microsoft site, there is no newsgroup that I see
that can satisfy general Access questions. Am I missing something?

Beth Melton said:
laurenm said:
Hi Beth,

It is a text field because in this report, my fields are based on a
query
results where I created a format expression that gives me a specific
format
not available in the default date/time format. If changing the field
to a
date/time format will matter to help me bold the results, I can
change it to
a date/time field and stick with an Access default. Please advise.
Click to expand...

The built-in formats, such as Short Date, are based on your Regional
Settings in your Control Panel.

If you want to use a specific format then just type it in the format
property: mm/dd/yyyy
What I am trying to do is display a project schedule where my
results
consist of projected dates of completion and actual completion dates
(if
there is a completed date to a task, I show the completed date, not
the
original projected date). In order to visually tell which dates are
completed
and which are projected I use a different format for each kind of
date. The
projected dates I show as a mm/dd/yy format and the completed dates
show as
mm/dd/yyyy format. I would like to bold the completed dates so it is
even
easier to distiguish between the two types of dates. Can someone
give any
insight as to how to do this (if it is even possible).
Click to expand...

You should have this separated in two fields, one for completion and
one for projected. Or, if your projected completion date is based on a
calculation of another date, such as start date, then use a calculated
field instead.

Then in your query for the field on your report use something like:

ReportDate: Nz([CompletionDate],[ProjectedDate])

Then just use a Conditional format for the ReportDate text box using
an Expression such as: [CompletionDate] Is Null

Also note there are newsgroups dedicated to Access. If you have any
future questions you'll likely find faster responses by posting to one
of the Access newsgroups. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
Thanks!
LaurenM
Click to expand...
Click to expand...
 
G

garfield-n-odie [MVP]

Access General Questions
http://www.microsoft.com/office/com...mspx?dg=microsoft.public.access&lang=en&cr=US

Access Reports
http://www.microsoft.com/office/com...microsoft.public.access.reports&lang=en&cr=US

Thanks, Beth. I will give this a try.

I would love to go to an Access-specific Newsgroup but when I go the the
Newsgroups area from the Microsoft site, there is no newsgroup that I see
that can satisfy general Access questions. Am I missing something?

:

Hi Beth,

It is a text field because in this report, my fields are based on a
query
results where I created a format expression that gives me a specific
format
not available in the default date/time format. If changing the field
to a
date/time format will matter to help me bold the results, I can
change it to
a date/time field and stick with an Access default. Please advise.
Click to expand...

The built-in formats, such as Short Date, are based on your Regional
Settings in your Control Panel.

If you want to use a specific format then just type it in the format
property: mm/dd/yyyy

What I am trying to do is display a project schedule where my
results
consist of projected dates of completion and actual completion dates
(if
there is a completed date to a task, I show the completed date, not
the
original projected date). In order to visually tell which dates are
completed
and which are projected I use a different format for each kind of
date. The
projected dates I show as a mm/dd/yy format and the completed dates
show as
mm/dd/yyyy format. I would like to bold the completed dates so it is
even
easier to distiguish between the two types of dates. Can someone
give any
insight as to how to do this (if it is even possible).
Click to expand...

You should have this separated in two fields, one for completion and
one for projected. Or, if your projected completion date is based on a
calculation of another date, such as start date, then use a calculated
field instead.

Then in your query for the field on your report use something like:

ReportDate: Nz([CompletionDate],[ProjectedDate])

Then just use a Conditional format for the ReportDate text box using
an Expression such as: [CompletionDate] Is Null

Also note there are newsgroups dedicated to Access. If you have any
future questions you'll likely find faster responses by posting to one
of the Access newsgroups. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

Thanks!
LaurenM

:


My first question is why you are storing a date as a Text data type
and not a Date/Time data type. Or is this a concatenated string?

Perhaps if you told us more about what you are trying to do exactly
we
might be able to help.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/



Hi All,

Is there a way to change the formatting in a report text field
based
on the
field meeting certain criteria? For example, if my text field has
the date
format of "mm" & "/" & "dd" & "/" & "yyyy", then apply a bold
format. I
looked into the conditional formatting but it didn't work for me.
Maybe I am
setting it up incorrectly. If anyone knows how to do this (if it
can
be done)
please let me know.

Thanks,
LaurenM
Click to expand...
Click to expand...
Click to expand...
 
L

laurenm

Fabulous!!! Thanks!!!

LaurenM

garfield-n-odie said:
Access General Questions
http://www.microsoft.com/office/com...mspx?dg=microsoft.public.access&lang=en&cr=US

Access Reports
http://www.microsoft.com/office/com...microsoft.public.access.reports&lang=en&cr=US

Thanks, Beth. I will give this a try.

I would love to go to an Access-specific Newsgroup but when I go the the
Newsgroups area from the Microsoft site, there is no newsgroup that I see
that can satisfy general Access questions. Am I missing something?

:

Hi Beth,

It is a text field because in this report, my fields are based on a
query
results where I created a format expression that gives me a specific
format
not available in the default date/time format. If changing the field
to a
date/time format will matter to help me bold the results, I can
change it to
a date/time field and stick with an Access default. Please advise.

The built-in formats, such as Short Date, are based on your Regional
Settings in your Control Panel.

If you want to use a specific format then just type it in the format
property: mm/dd/yyyy


What I am trying to do is display a project schedule where my
results
consist of projected dates of completion and actual completion dates
(if
there is a completed date to a task, I show the completed date, not
the
original projected date). In order to visually tell which dates are
completed
and which are projected I use a different format for each kind of
date. The
projected dates I show as a mm/dd/yy format and the completed dates
show as
mm/dd/yyyy format. I would like to bold the completed dates so it is
even
easier to distiguish between the two types of dates. Can someone
give any
insight as to how to do this (if it is even possible).

You should have this separated in two fields, one for completion and
one for projected. Or, if your projected completion date is based on a
calculation of another date, such as start date, then use a calculated
field instead.

Then in your query for the field on your report use something like:

ReportDate: Nz([CompletionDate],[ProjectedDate])

Then just use a Conditional format for the ReportDate text box using
an Expression such as: [CompletionDate] Is Null

Also note there are newsgroups dedicated to Access. If you have any
future questions you'll likely find faster responses by posting to one
of the Access newsgroups. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


Thanks!
LaurenM

:


My first question is why you are storing a date as a Text data type
and not a Date/Time data type. Or is this a concatenated string?

Perhaps if you told us more about what you are trying to do exactly
we
might be able to help.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/



Hi All,

Is there a way to change the formatting in a report text field
based
on the
field meeting certain criteria? For example, if my text field has
the date
format of "mm" & "/" & "dd" & "/" & "yyyy", then apply a bold
format. I
looked into the conditional formatting but it didn't work for me.
Maybe I am
setting it up incorrectly. If anyone knows how to do this (if it
can
be done)
please let me know.

Thanks,
LaurenM
Click to expand...
Click to expand...
Click to expand...
 
Top