Reading row length

[dnlhmpt]

I have searched and searched for this and have found similar issues but nothing quite like this.



We are using Access 2010 to output a text file with records from our db. If everything go correctly all of the rows in the text file contain a different record and each row should be 599 chars in length. The issue is, if any data is missing from one of the records it will shorten the length of the row to less than 599 chars.

Do any of you know if there is a way to get access to make the text file but then check it and let us know if any rows are less than 599 chars in length?

Thank you

[June7]

Would have to read each row of data and test its length with Len function. How many fields are involved? Build a query that concatenates all the fields to one string and filter for any record where Len(string) <> 599.

[dnlhmpt]

Thank you very much.
I did like you were saying and instead of reading the text file we just set it up to check the rows of the temp table before it is even exported. It works great now!

Thank you again