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

• Microsoft Access 2000

SYMPTOMS

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

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 <BR> tag in the HTML code. Replace the <BR> tag with &nbsp;; then, the table will correctly display the blank records.

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

1. Start Microsoft Access and create a new table named TstHTMLBlank. In Design view, create two fields: TestName as Text, and TestDate as Date.



2. Add eight records to the table.



3. 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.



4. Save and close the table.



5. On the File menu, click Export.



6. On the "Export Table TstHTMLBlank As" screen, move to the My Documents folder.



7. Click the arrow in the Save As Type box, select HTML Documents, and then click Save.



8. 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.



9. 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.



10. 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> 

11. Use a text editor, such as Notepad, to replace the <BR> tag with &nbsp; as follows:




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

   </TR> 

12. On the File Menu, click Save.



13. Click Close.



14. 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

1. Repeat steps 1 through 9 in the "Resolution" section to create the HTML file.



2. Open Microsoft Internet Explorer.



3. On the File menu, click Open.



4. In the Open dialog box, click Browse.



5. In the Look In box, browse to the My Documents folder.



6. 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 : kbdta IntAsp
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb