Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Enter Key doesn't seem to be working...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Enter Key doesn't seem to be working...
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
cspano View Drop Down
Newbie
Newbie


Joined: 13 March 2010
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote cspano Quote  Post ReplyReply Direct Link To This Post Topic: Enter Key doesn't seem to be working...
    Posted: 16 March 2010 at 8:02pm
Using version ReportControl 13.3.1,

When editing the contents of a cell, the Enter Key doesn't appear to have any effect (and I can't trap the KeyDown event). This prevents the user from hitting 'Enter' if after they've typed in the desirable cell contents (in order to indicate they they've finished entering data in that cell).

All settings are default except as follows:
Set rc = Me.ReportControl1.Object
    rc.PaintManager.FixedRowHeight = False ' allows for multi-line headers
    rc.BorderStyle = xtpBorderFrame
    rc.AllowEdit = True

columns have following settings:
    Column.EditOptions.SelectTextOnEdit = True
Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2010 at 12:04pm
Hi,
 
I can't reproduce what you mentioned, I'm able to use ENTER key and caption does change.
Can you upload test project ?
 
 
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....
Back to Top
cspano View Drop Down
Newbie
Newbie


Joined: 13 March 2010
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote cspano Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2010 at 1:00pm
Unfortunately, I'm using the Report Control on a MSAccess (2003) Form, which is connected to a MSSQLServer 2005 database on a network. I will attempt to extract all the relevant code and objects into a stand-alone MDB file to allow you to reproduce the error...
Back to Top
cspano View Drop Down
Newbie
Newbie


Joined: 13 March 2010
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote cspano Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2010 at 1:44pm
OK here's a small MDB file which demonstrates the problem(s) effectively.

There's just one form, 'Test Form'. Column #2 and column #3 are both editable (via double click). Assuming that you experience the same results that I do, you will see that the Enter key has no effect when editing a cell.

Also notice that any changes that are made in the 3rd column are not accepted (they revert back to the original value when the user leaves the cell or presses Tab). I'm not sure if this problem is related.

20100319_134426_CodeJockTest.zip
Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2010 at 6:35am
Hi,
 
I didn't know you used RC in Access database... I tried with your sample and you are right about the ENTER key. It doesn't do anything when pressing ENTER key and also NO event is fired. The other thing you mentioned I can't reproduce, the value changes when using TAB key or selecting other cell.
 
I will add problem to my list and wait for response of support
 
Thanks
 
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....
Back to Top
cspano View Drop Down
Newbie
Newbie


Joined: 13 March 2010
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote cspano Quote  Post ReplyReply Direct Link To This Post Posted: 22 March 2010 at 2:42pm
Thanks for your efforts. For the second issue, I've found a workaround regarding the null values in the 3rd column (basically, I don't assign a Null value, instead I convert nulls to zero-length strings).

The bigger issue is the Enter Key behavior. That is a major inconvenience for my end user who expects normal behavior during data entry situations. I eagerly await for a solution...
Back to Top
tompat View Drop Down
Newbie
Newbie


Joined: 19 August 2012
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tompat Quote  Post ReplyReply Direct Link To This Post Posted: 19 August 2012 at 3:20pm
Hello,

This still appears to be an issue when using Report Control with MS Access. I am using version 15.3.1 with Access 2010. 

When AllowEdit = True is set, neither the Enter key or Up/Down arrows work.

This is a serious concern as it renders the control unusable for my users. 

Please could you let me know if there is a fix/workaround?

Many thanks,

Tom
Back to Top
Xander75 View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 April 2007
Status: Offline
Points: 353 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Xander75 Quote  Post ReplyReply Direct Link To This Post Posted: 21 August 2012 at 5:38am
Originally posted by tompat tompat wrote:

Hello,

This still appears to be an issue when using Report Control with MS Access. I am using version 15.3.1 with Access 2010. 

When AllowEdit = True is set, neither the Enter key or Up/Down arrows work.

This is a serious concern as it renders the control unusable for my users. 

Please could you let me know if there is a fix/workaround?

Many thanks,

Tom


Strange, I have v15.3.1 installed and this works fine. I can get the Enter key and Arrow keys to fire in the PreviewKeyDown event when in editmode for the ReportControl.

Private Sub ReportControl_PreviewKeyDown(KeyCode As Integer, ByVal Shift As Integer, Cancel As Boolean)
    Select Case KeyCode
        Case 13
            ' Your code on Enter goes here...
           
        Case vbKeyDown
            ReportControl.Navigator.MoveDown True, True
            ReportControl.Navigator.BeginEdit
            Cancel = True
            
        Case vbKeyLeft
            ReportControl.Navigator.MoveLeft True, True
            ReportControl.Navigator.BeginEdit
            Cancel = True
            
        Case vbKeyRight
            ReportControl.Navigator.MoveRight True, True
            ReportControl.Navigator.BeginEdit
            Cancel = True
            
        Case vbKeyUp
            ReportControl.Navigator.MoveUp True, True
            ReportControl.Navigator.BeginEdit
            Cancel = True
    End Select
End Sub
Product: Xtreme SuitePro (ActiveX) v15.3.1
Platform: Windows 7 64-bit (SP1) Professional Edition
Languages: C#.Net using Visual Studio 2012 & Visual Basic 6.0 (SP6)
Back to Top
tompat View Drop Down
Newbie
Newbie


Joined: 19 August 2012
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tompat Quote  Post ReplyReply Direct Link To This Post Posted: 21 August 2012 at 6:57pm
Hello, any response to this long standing issue?

Many thanks,

Tom
Back to Top
tompat View Drop Down
Newbie
Newbie


Joined: 19 August 2012
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tompat Quote  Post ReplyReply Direct Link To This Post Posted: 23 August 2012 at 4:29pm
Works perfectly. Thank you Xander75!

Tom
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.203 seconds.