|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 22nd, 2005, 07:00 PM
posted to microsoft.public.access.reports
|
|||
|
|||
what charactor to hold number space in conditional formating
|
|
#2
November 22nd, 2005, 07:12 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
what charactor to hold number space in conditional formating
Is there a question here? Your Subject doesn't make much sense to me.
Please feel free to use the body of your posting to fully describe your situation and question. -- Duane Hookom MS Access MVP "fpb34" wrote in message ...
|
|
#3
November 22nd, 2005, 07:14 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
what charactor to hold number space in conditional formating
On Tue, 22 Nov 2005 11:00:03 -0800, fpb34 wrote:
This is the area of your message where you're supposed to ask a question, not the subject line. Besides which, your subject line does not make much sense. Why not try again and spend a bit of time explaining what you mean. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#4
November 22nd, 2005, 07:28 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
what charactor to hold number space in conditional formating
"fredg" wrote: On Tue, 22 Nov 2005 11:00:03 -0800, fpb34 wrote: This is the area of your message where you're supposed to ask a question, not the subject line. Besides which, your subject line does not make much sense. Why not try again and spend a bit of time explaining what you mean. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Sorry guys first time. what I am asking is when using conditional formating in a report, what charactor could I use in a 5 digit number to only use the conditons on the last 2 numbers?
|
|
#5
November 22nd, 2005, 08:46 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
what charactor to hold number space in conditional formating
If the 5 digit number is text then
Expression Is Right([YourFieldExpression],2) = "__" If numeric, consider Right(str([YourFieldExpression]),2) = "__" -- Duane Hookom MS Access MVP -- "fpb34" wrote in message ... "fredg" wrote: On Tue, 22 Nov 2005 11:00:03 -0800, fpb34 wrote: This is the area of your message where you're supposed to ask a question, not the subject line. Besides which, your subject line does not make much sense. Why not try again and spend a bit of time explaining what you mean. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Sorry guys first time. what I am asking is when using conditional formating in a report, what charactor could I use in a 5 digit number to only use the conditons on the last 2 numbers?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Access Limits (file size, table records, users) | Mike | General Discussion | 4 | November 4th, 2005 03:01 AM |
| lock record using conditional formating | Bessie | General Discussion | 1 | November 2nd, 2005 07:48 PM |
| Counting the number of cells meeting conditional formating criteria | Jeff | Worksheet Functions | 4 | July 9th, 2005 01:18 AM |
| Conditional formating | Manu Arora | Worksheet Functions | 4 | June 9th, 2004 10:47 PM |
| Conditional Formating | Brw | Worksheet Functions | 3 | December 9th, 2003 03:12 PM |
Linear Mode
