J2ee web hosting - Description: Decimal placeholder. The actual character displayed as
Description: Decimal placeholder. The actual character displayed as a decimal placeholder depends on the international settings of the local Windows system. (% ) Description: Percentage placeholder. Displays expression as a percentage by first multiplying the value of expression by 100. Example: Format(0.25, “##.00%”) returns 25.00% (, ) Description: Thousands separator. The actual character displayed as a thousands separator depends on the international settings of the local Windows system. You only need to show one thousands separator in your definition. Example: Format(1000000, “#,###”) returns 1,000,000 (E- E+ e- e+ ) Description: Scientific format. If the format expression contains at least one digit placeholder (0 or #) to the right of E-, E+, e-, or e+, the number is displayed in scientific format, and the letter E or e that was used in the format expression is inserted between the number and its exponent. The number of digit placeholders to the right determines the number of digits displayed in the exponent. Use E-or e-to place a minus sign next to negative exponents. Use E+ or e+ to place a minus sign next to negative exponents and a plus sign next to positive exponents. - + $ ( ) Description: Displays a literal character. Example: Format(2345.25,”$#,###.##”) returns $2,345.25 ( ) Description: The character following the backslash will be displayed as a literal character. Use the backslash to display a special formatting character as a literal. Example: Format(0.25, “##.00%”) returns .25% Note: Note the difference between the result of this example and the result of the % formatting character. Programming Tips and Gotchas A little known and very important use of the Format function is to prevent an “Invalid Use of Null” error from occurring when assigning values from a recordset to a variable within your program. For example, if a field within either a DAO or RDO recordset created from either an Access or SQL Server database contains a Null value, you could trap this and change its value to “” as follows: If IsNull(rsMyRecordSet!myValue) Then sMyString = “” Else sMyString = rsMyRecordSet!myValue
Note: If you are looking for cheap and inexpensive provider to host and run your tomcat application check Actions tomcat hosting services