Microsoft KB Archive/145769

= PRB: Capital "S" Not Displayed When Using the Text ISAM =

Article ID: 145769

Article Last Modified on 3/16/2005

-

APPLIES TO


 * Microsoft Visual Basic 4.0 Standard Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 Enterprise Edition

-



This article was previously published under Q145769



SYMPTOMS
Text files that contain a capital "S" in a column by themselves display as "0". The rest of the characters for that column are not displayed.



RESOLUTION
The preceding file is not in the format Visual Basic expects; comma separated text needs to be in the following format:   "FirstName", "MiddleInitial", "LastName", "age", "address" "Chris","B","Barr",30,"200 main st" "Charles","S","Sterling",27,"100 1st street"



STATUS
This behavior is by design.



MORE INFORMATION
The text file is not in the format Visual Basic expects it to be in. Visual Basic expects to find "" around each and every entry in the text file.

Steps to Reproduce the Problem
  Create a text file with following text. Save it as a text file.  FirstName, MiddleInitial, LastName, age, address Chris ,B ,Barr ,30, 200 main st     Charles ,S, Sterling, 27 ,100 1st street  Start Visual Basic. Form1 is created by default. Add a data control to form1. In the properties for the data1 control, choose Text for the connect property and select the text file for the database name. Add a DBGrid control to the form and select Data1 as the datasource.</li>  Run the project (press F5). Results: <pre class="fixed_text">     Chris       Barr      30  200 main st      Charles  0  Sterling  27  100 1st street The "B" middle initial (in the first record) is now blank. The "S" middle initial (in the second record) is now a "0". </li></ol>

<div class="references_section">