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
|
|||
|
|||
what charactor to hold number space in conditional formating
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |