Codejock Developer Community : [SOLVED] Best way to limit input in cell

[SOLVED] Best way to limit input in cell : Great, thanks for the help!

Wed, 06 Apr 2011 14:13:10 +0000

Author: wakerunner
Subject: 18156
Posted: 06 April 2011 at 2:13pm

Great, thanks for the help!

[SOLVED] Best way to limit input in cell : Hi, You can alsoprevent user...

Sun, 03 Apr 2011 11:56:34 +0000

Author: Aaron
Subject: 18156
Posted: 03 April 2011 at 11:56am

Hi,

You can also prevent user from typing non numerical characters... And following does for entire column. You can also set this for single ReportItem when adding records.

With wndReportControl

.AllowEdit = True

            With .Columns
                With .Add(.Count, "Col 1", 100, True)
                    .EditOptions.EditControlStyle = xtpEditStyleNumber
                End With

End With

[SOLVED] Best way to limit input in cell : This is how I have done thisPrivate...

Sun, 03 Apr 2011 10:27:48 +0000

Author: markmark
Subject: 18156
Posted: 03 April 2011 at 10:27am

This is how I have done this

Private Sub wndReport_InplaceEditChanging(ByVal Row As XtremeReportControl.IReportRow, ByVal Column As XtremeReportControl.IReportColumn, ByVal Item As XtremeReportControl.IReportRecordItem, newValue As String, Cancel As Boolean)
If Len(newValue) <> 0 Then
Cancel = Not IsNumeric(newValue)
End If
End Sub

[SOLVED] Best way to limit input in cell : I have cells that I want to...

Sat, 02 Apr 2011 16:06:08 +0000

Author: wakerunner
Subject: 18156
Posted: 02 April 2011 at 4:06pm

I have cells that I want to allow input of numbers only, what is the best way to do this? I don't see a keypress event, is the "previewkeydown" event the only way to do this?