Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Numbers xtpEditStyleNumber
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Numbers xtpEditStyleNumber
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
markmark View Drop Down
Senior Member
Senior Member


Joined: 30 November 2007
Status: Offline
Points: 142 		Post Options Post Options   Thanks (0) Thanks(0)   Quote markmark Quote  Post ReplyReply Direct Link To This Post Topic: Numbers xtpEditStyleNumber
    Posted: 15 April 2010 at 8:45am
Hi
 
I am using this code
 
    Set Item = rRecord.AddItem("")
    Item.CreateEditOptions
    Item.EditOptions.EditControlStyle = xtpEditStyleNumber
 
This allows only numbers, but I would like to be able to enter values with a decimal point ie 12.123
But it only allows whole numbers, is there away to do this?
 
Thanks
 
Mark
Product: Xtreme SuitePro (ActiveX) version 13.0.0
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0
Back to Top
jpbro View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 January 2007
Status: Offline
Points: 1357 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jpbro Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2010 at 10:11am
You can use the InplaceEditChanging event along the lines of this:


Private Sub repServers_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


Although that would allow currency symbols as well (and negative values). You can expand your testing as required if you don't want to allow such values.
Product: Xtreme SuitePro (ActiveX) version 16.2.6
Platform: Windows XP - SP3

Language: Visual Basic 6.0 SP6
Back to Top
markmark View Drop Down
Senior Member
Senior Member


Joined: 30 November 2007
Status: Offline
Points: 142 		Post Options Post Options   Thanks (0) Thanks(0)   Quote markmark Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2010 at 10:59am
Thanks jpbro that works for me.
 
Cheers
Product: Xtreme SuitePro (ActiveX) version 13.0.0
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0
Back to Top
jpbro View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 January 2007
Status: Offline
Points: 1357 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jpbro Quote  Post ReplyReply Direct Link To This Post Posted: 15 April 2010 at 1:35pm
Glad to help!
Product: Xtreme SuitePro (ActiveX) version 16.2.6
Platform: Windows XP - SP3

Language: Visual Basic 6.0 SP6
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.