database field contains ########## characters

[bluerain25]

hi people

i got 46 rows of records in my table that contains ########## characters. I could not determine what causes this error. i dont want to delete this for i dont know what will happen to other data in another table that is link to the fields on this table. please help.. the table is used to store all the transactions and is link to the accounts, clients, signatory table. please help. thanks

 

[Remou]

Was the database corrupted and repaired at any time? Have you got a number of back-ups that you can examine back through time to see when this occurred and what the original data was?

 

[SgtJarrow]

Do you mean you are seeing #### characters when you view the table or query based on the table?? If so, have you tried expanding the field so it is wider??

Access just visually replaces the true characters with #### characters when the field is too small to show it...It does not change the underlying data though.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[jsteph]

Is the field a memo field? If so, you'll likely need to delete the record, and if I recall, you may need to delete it in code, not via the datasheet view.
--jim