The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Knowledge Base

ACC97: Blank Records Do Not Show in Table Exported as HTML

Article ID: 174089

Article Last Modified on 1/20/2007

APPLIES TO

Microsoft Access 97 Standard Edition

This article was previously published under Q174089

Advanced: Requires expert coding, interoperability, and multiuser skills.

SYMPTOMS

When you export a table that contains consecutive blank records to HTML format, you see one blank line instead of a blank line for each record.

RESOLUTION

NOTE: This example contains information about editing ASP files. It assumes that you are familiar with Active Server, Visual Basic Scripting, and editing HTML files. Microsoft Access Product Support professionals do not support modification of any HTML, HTX, IDC, or ASP files.

When you export a table to HTML format, the blank record is represented by a
tag in the HTML code. Replace the
tag with ; then, the table will correctly display the blank records.

To see the blank records displayed correctly, follow these steps:

Start Microsoft Access and create a new table named TstHTMLBlank. In Design view, create two fields: TestName as Text, and TestDate as Date.
Add eight records to the table.
Use the BACKSPACE key to remove five consecutive records. Do not use the DELETE key to remove the records; you only want to remove the data so that the fields are empty.
Save and close the table.
On the File menu, click Save As HTML. When the "Publish to Web Wizard" appears, click Next on the opening screen.
On the "What do you want to publish?" screen, click the TstHTMLBlank table, and then click Next.
Click Next on the screen that prompts you to select a default template.
On the "What default format type do you want to create?" screen, click Static HTML, and then click Next.
On the "Where do you want to publish to?" screen, select C:\My Documents, and then click Finish.
Open Microsoft Internet Explorer, and then follow these steps:
1. On the File menu, click Open, and then click Browse.
2. In the Open dialog box, in the "Look In" box, browse to the My Documents folder.
3. In the My Documents folder, select the TstHTMLBlank_1.html file, and then click Open.
In the Open dialog box, click OK.

Note that you see the table displayed with one blank line instead of a blank line for each blank record as expected.

Using the right mouse button, click the screen, and then click View Source on the menu that appears.

Note that for each blank record, a line similar to the following appears in the source:

        <TR VALIGN=TOP>
        <TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial"
            COLOR=#000000><BR></FONT></TD>
        <TD BORDERCOLOR=#c0c0c0  ALIGN=RIGHT><FONT SIZE=2 FACE="Arial"
            COLOR=#000000><BR></FONT></TD>

        </TR>

Use a Text Editor, such as Notepad, to replace the
tag with as follows:

        <TR VALIGN=TOP>
        <TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial"
            COLOR=#000000> </FONT></TD>
        <TD BORDERCOLOR=#c0c0c0  ALIGN=RIGHT><FONT SIZE=2 FACE="Arial"
            COLOR=#000000><BR></FONT></TD>

        </TR>

On the File Menu, click Save.
Click Close.
On the View Menu, click Refresh. Note that the table displays the lines for the blank records as expected.

MORE INFORMATION

Steps to Reproduce Behavior

Repeat steps 1 through 9 in the "Resolution" section to create the HTML file.
Open Microsoft Internet Explorer.
On the File menu, click Open.
In the Open dialog box, click Browse.
In the Look In box, browse to the My Documents folder.
In the My Documents folder, select TstHTMLBlank_1.HTML. Click Open, and then click OK in the Open Dialog Box.

Note that the table is displayed, and you see one blank line instead of a blank line for each record.

Keywords: kbprb KB174089

Microsoft KB Archive/174089

Contents