A dirturbing question

[sabavno]

Hi

I just imported a data from another table. What bothers me is that for instance, a record has field LastName filled in in the table, but when I look at that record on the form, LastName does not show up.
That only happens to a few records, where as the rest of the records do show up on the forms fine

Please suggest what may be causing the problem?

Thanks

 

[ETID]

Could there be leading or trailing spaces in those fields?

combine that with some weird justificaton in the form and it could "appear" as though the info is not there?

....just a thought

 

[OldTom]

A few more thoughts for you

Is the form based on a query, and if so are there are conditonal elements in the query that relate to to the control source for the field?

Is there any conditional formatting that effectively hides that field by making background and foreground the same colour?

Is there any code in in LOAD that hides that control?

Tom

 

[MichaelRed]

While I'm not offering a soloution, this is a good (bad?) example showing WHY it is POOR practice to directly import 'stuff'. You should import 'stuff' into a teporary table (and on some occassions a seperate db) do V&V (Verification and Validation) of the raw 'stuff', checking for oddities like padded strings, illegal characters (like "$" in ammounts), invalid dates (13/2/02) BEFORE adding the 'stuff' to a live db. Since the 'deed is done' here, one can only suggest that the entire recordset NOW needs to have V&V applied to it. A MINOR help could be to add a date/time stamp field to the recordset, and have it default to "Now()". IF at least that is present AND the db is locked during the bulk import, you can identify all of the records imported at the 'same' time.


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over