<div>
Thanks for replying so quickly! :-) 
 
When I set a break on line 8 then typ ?erl in the intermediate screen it returns 0. 
Is erl only set if an error occurs? 
 

<pre><code class="code-1 nolinks" id="code-124312">1 FillControls
2
3 If Trim(Me.txtNRCredNr) = &quot;&quot; Then Me.txtNRCredNr = 0
4 If Trim(Me.txtNRDebNr) = &quot;&quot; Then Me.txtNRDebNr = 0
5 If Trim(Me.txtPayDays) = &quot;&quot; Then Me.txtPayDays = 0
6 If Trim(Me.txtCreditLimit) = &quot;&quot; Then Me.txtCreditLimit = 0
7
8 If gsOffice = &quot;ThisOne&quot; Then
</code></pre>
</div>

<div>
Hahaha hohoho and @#$% !!!! 
So many hours wasted typing menial code!!! Nearly enough to make me cry !!!! 
 
I hereby promote you all to the highest rank of whatever religion or way of life you follow. 
 
Man, I'm sitting here with my head in my hands and wry smile on my face. 
 
Been programming in VB6 for 5 years, with only EE and google to brainstorm with. 
The program was being used before I found out about functions and errorhandling. 
The person I learnt from (With 12 years experience), didn't know about these either....... 
 
40 forms, 5 datareports, 45 tables, 30 views, 15 stored procedures and 40 irritated users. 
This tool would have saved me hundreds of hours and my hair color!! 
 
Oh well.... got any more tips.....? 
 
Shame I can only split 500 points for this answer. This is worth a billion points to each of you to me!! 
 
Thanks MZTools! 
 
I love this site! 
When the law allows for it, i'll propose. 

</div>

<div>
Glad to be of assistance. 
 
AW
</div>

<div>
<div class="content wysiwyg-content">
In a Visual Basic 6 form I can enter row numbers in the left margin. 
These numbers pass through the compiler. 
 
How can I return a row number in an error message? 
E.g. ERROR Form CustomerDetails | &nbsp;Row 10 | 13 Type Mismatch 
 
I hope to cut down the time it takes to find handled errors.
</div>
</div>

In a Visual Basic 6 form I can enter row numbers in the left margin.
These numbers pass through the compiler.

How can I return a row number in an error message?
E.g. ERROR Form CustomerDetails |  Row 10 | 13 Type Mismatch 

I hope to cut down the time it takes to find handled errors.

VB6 : How to return row number where an error occured

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.