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
|
|||
|
|||
Expression Builder
I'm running a report which contains a lot of currency=20
fields in each record. If an entry isn't made in a record=20 Access automatically enters the value as "=A30.00". I want=20 it to just be black, or for value's 0 to be bold. I=20 can't quite get the expression right. what should I do? |
#2
|
|||
|
|||
Sara,
No, Access does not "automatically enter the value as '£0.00'". It means the data in the query that the report is based on is returning 0. This may well be because the fields in question have their Default Value set to 0 in either the table design or the data entry forms. There are a number of possible approaches, and the best one would depend on the actual details of your project. You could try removing the default value for the fields (and running an Update Query to remove the 0 values from the existing records). You could use calculated fields in the report's underlying query, in the place of the existing fields, using syntax such as... RealMoney: IIf([YourCurrencyField]=0,Null,[YourCurrencyField]) You could set the Format property of the textboxes on the report to something like: £#,##0.00;(£#,##0.00);"";"" Or, you could use Conditional Formatting on the textboxes, for Field Value equal to 0 set the forecolor to white. You can also use Conditional Formatting to set up for Bold font for amounts 0. Conditional Formatting is found under the Format menu in the report design view. -- Steve Schapel, Microsoft Access MVP wrote: I'm running a report which contains a lot of currency fields in each record. If an entry isn't made in a record Access automatically enters the value as "£0.00". I want it to just be black, or for value's 0 to be bold. I can't quite get the expression right. what should I do? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
non-functional Expression Builder | Larry | Running & Setting Up Queries | 0 | August 26th, 2004 03:00 PM |
expression not working in report - help! | Melanie | Setting Up & Running Reports | 2 | August 20th, 2004 03:42 PM |
need help with a relatively simple criteria expression | Paul James | Running & Setting Up Queries | 9 | August 17th, 2004 11:24 PM |
Expression Builder | Hai Le | General Discussion | 3 | August 13th, 2004 06:06 PM |
Carriage Returns in Expression Builder | Joe Cooke | Setting Up & Running Reports | 3 | May 24th, 2004 03:06 PM |