<div>
Cant speak for the grid your talking about, but if EditMask works the same way as the Format function then the EditMask your looking for would be<br />
<br />
..EditMask = &quot;0000000&quot;<br />
<br />
Dont know if it'll work but its worth a go.<br />
<br />
Gordon<br />

</div>


Cant speak for the grid your talking about, but if EditMask works the same way as the Format function then the EditMask your looking for would be

..EditMask = "0000000"

Dont know if it'll work but its worth a go.

Gordon


<div>
Didn't work Gordon. &nbsp;The column data did display as &quot;0000000&quot; but it would not allow me to edit the data. &nbsp;Thanks for the idea though.
</div>


Didn't work Gordon.  The column data did display as "0000000" but it would not allow me to edit the data.  Thanks for the idea though.

<div>
<div class="content wysiwyg-content">
I am using a Apex True DBGrid Pro 6.0, and in one of my columns I need to only allow the users to enter a maximum of 7 digits. &nbsp;I tried using the code below:<br />
<br />
&nbsp; With dbgTransData.Columns(&quot;Case<wbr /> Num&quot;)<br />
&nbsp; &nbsp; .Width = 1100: .Caption = &quot;Case Num&quot;: .Alignment = dbgRight<br />
&nbsp; &nbsp; .EditMask = &quot;#######&quot;: .NumberFormat = &quot;Edit Mask&quot;: .HeadAlignment = dbgCenter<br />
&nbsp; End With<br />
<br />
The code works as far as only allowing the user to enter 7 digits but I need the default value to display as &quot;0000000&quot;. &nbsp;The code above displays a default value of &quot;0&quot; centered in the column. &nbsp;<br />
<br />
Any ideas on how to get what I am trying to accompish to work?
</div>
</div>


I am using a Apex True DBGrid Pro 6.0, and in one of my columns I need to only allow the users to enter a maximum of 7 digits.  I tried using the code below:

  With dbgTransData.Columns("Case Num")
    .Width = 1100: .Caption = "Case Num": .Alignment = dbgRight
    .EditMask = "#######": .NumberFormat = "Edit Mask": .HeadAlignment = dbgCenter
  End With

The code works as far as only allowing the user to enter 7 digits but I need the default value to display as "0000000".  The code above displays a default value of "0" centered in the column.  

Any ideas on how to get what I am trying to accompish to work?

Apex True DBGrid Pro 6.0 Edit Mask Question

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.