I am using "=Format(,"(000) 000-0000") & " / " & " in a report to display the telephone number from two fields (txtCustTN1 and txtCustTN2). It works fine as...

Hello, I've searched the forum, but I can't find exactly what I'm looking for. On an invoice, I have the addresses broken out in separate fields:...

I am trying to manually format for a label not found using the label wizard. The specs are 105mm x 36mm; 8 rows, 2 cols; no space between labels; A4...

I created a report off of a query that has running totals in it. Right now, I have the grand total in the report footer showing me 117 minutes. How can I...

I have what I hope is a VERY simple question. I need to replicate the Excel "Accounting" format, i.e. negative numbers are in parenteses ($2,000.00) and red. ...

I have created a chart in an Access report. I have picked the option to display the datatable with the chart. All of the data being displayed is stored as...

I cannot get my report to retain the currency format when previewed. It looks fine in design view, but does not retain it. I have changed all of the...

I have a text box with numbers and words. I am trying to format the numbers to currency and it will not allow me to because the output can also be a...

I have a numerical field that I cannot format - it continues to show 8 decimal places even after I change the format to general or standard and set decimal...

Hello I have a table called folders, and the primary key (FolderID) is the number of the folder. so it's not automatic, but of course unique. and it's a...

I have a report with 6 headers. I also have code behind each headers On Format property. As I halt the code the progression seems strange. I mean it seems to...

i have a report with 3 subreports that show percentages calculated in the subreport from fields calculated in a query. i am trying to have the fields that...

I would like to format numbers in my report as follows: If the number is an integer, display the number, if the number is not display 2 decimal places. I...

Have Access 2002 dB with reports based on queries, and VBA form to access reports. When attempt to preview some reports, report hangs, shows only "Formatting...

I have an invoicing report with a subreport. This is your standard invoicing program. Within the subreport I have another subreport with comments about this...

I need to create and print a certificate of completion for a seminar and my user wants the following: 1. Instructor(s) name and title centered. There may...

I have an input mask for a field call Cell Phone: !\(999") "000\-0000;0;_ When I use that field to print on my report, I'm getting this to display? (999)...

Short story: My problem is that Access mangles the formatting when I try to export the report to Excel. I would like to export the reports to something like...

I have a access 2003 report with a text box in it. WHen I print preview, the text is centered horizontally. How do I have the text centered vertically as...

I have a query that “always� returns at most, 4 rows. I would like to present the rows in a report, with the data formatted as columns on the report. As...