Question on dBASE III and indexes 
Author Message
 Question on dBASE III and indexes

I am creating a simple form with bound controls and unbound controls.  When
using the unbound controls with an index open I get the word "NULL" printing
on my report for all blank fields.  Also when doing a search with the index
and try to put the results into the appropriate text boxes I get an error when
it hits a field that is null.  The error is something about the object not
being set.

How can I get rid of this "NULL" problem?

Any help would be great.

Dan



Wed, 20 Oct 1999 03:00:00 GMT  
 Question on dBASE III and indexes

set the textbox.text = recordset!field & ""
That will appenbd an empty string and rid you of the null values

--
_____________________________________________________________________

                            Endless Knot Enterprises
                      Custom Computer Solution Developers
                       http://www.xtalwind.net/~endlessknot
_____________________________________________________________________



Quote:
> I am creating a simple form with bound controls and unbound controls.
When
> using the unbound controls with an index open I get the word "NULL"
printing
> on my report for all blank fields.  Also when doing a search with the
index
> and try to put the results into the appropriate text boxes I get an error
when
> it hits a field that is null.  The error is something about the object
not
> being set.

> How can I get rid of this "NULL" problem?

> Any help would be great.

> Dan




Thu, 21 Oct 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Using DBase III index in VB5

2. VB4.0 16-bit using dBase III Indexes

3. dBASE III indexes

4. dBASE III/IV & FoxPro Index files

5. Indexing atached dBase III tables

6. dBase III Index and VB4

7. Using indexes with dBase III

8. dBASE III indexes

9. Problem writing to a Dbase III table and updating the indexes

10. Rebuild dBase III indexes from VB

11. Please Help!!!! Trouble creating/using dbase III indexes

12. Dbase III database with indexes

 

 
Powered by phpBB® Forum Software