B
Bennet-Tec Staff
I trying to track down a problem specific to the Access environment,
with interuption of Delete and Backspace key in an ActiveX
component.
The problem only occurs in Access
and behaves differently for different versions of Access and dependent
on whether the compoent is placed on a bound or unbound form.
The activeX control is MetaDraw 3 OCX - this is a component
my company created and markets.
Our MetaDraw component is a vector oriented image component.
One of the features is the ability to add text objects to the drawing
and edit these in place. When the user adds a text object he
clicks
down with his mouse and then starts typing at that location. If he
wants he can use the back arrow to move to the left within the text
and then hit Delete to delete the character to the right ( just like
in
any text editor ). For some reason, dependent on the version of
Access and whether the Access form is bound or not ( ie whether
there is a data control ) the Delete key and Backspace keys have
no effect when used while editing Text in MetaDraw on an Access form,
but it works just fine when MetaDraw is placed in any other
environment - on a VB Form, in C++, within a web browser page, or even
in an Excel spreadsheet.
1. In Access 2007/2010 UNBOUND form ( no Data
control )
backspace key works
delete key works
2. In Access 2007/2010 BOUND form ( with Data
control ) :
backspace key NOT working
delete key does NOT work
3. In Access 2000 bound form or unbound form:
backspace key works
delete key does NOT work
4) All other environments ( VB, C++, FoxPro,
Excel, ... )
- Backspace and Delete work fine
As the problem only exists in Access and is dependent on the
Access version and binding to data, I was wondering if anyone
can think of any reason Access may interfere with the processing
of the Delete and/or Backspace key within an ActiveX object
on an Access form, and whether there is any simple solution
- maybe something obvious I am overlooking in Access.
Basically I just want to do all I can to help our customers and am
looking
for some solution.
If there is a better newsgroup for posting the question please do let
me know.
Jeff Bennett
Jeff @ btis DOT com
with interuption of Delete and Backspace key in an ActiveX
component.
The problem only occurs in Access
and behaves differently for different versions of Access and dependent
on whether the compoent is placed on a bound or unbound form.
The activeX control is MetaDraw 3 OCX - this is a component
my company created and markets.
Our MetaDraw component is a vector oriented image component.
One of the features is the ability to add text objects to the drawing
and edit these in place. When the user adds a text object he
clicks
down with his mouse and then starts typing at that location. If he
wants he can use the back arrow to move to the left within the text
and then hit Delete to delete the character to the right ( just like
in
any text editor ). For some reason, dependent on the version of
Access and whether the Access form is bound or not ( ie whether
there is a data control ) the Delete key and Backspace keys have
no effect when used while editing Text in MetaDraw on an Access form,
but it works just fine when MetaDraw is placed in any other
environment - on a VB Form, in C++, within a web browser page, or even
in an Excel spreadsheet.
1. In Access 2007/2010 UNBOUND form ( no Data
control )
backspace key works
delete key works
2. In Access 2007/2010 BOUND form ( with Data
control ) :
backspace key NOT working
delete key does NOT work
3. In Access 2000 bound form or unbound form:
backspace key works
delete key does NOT work
4) All other environments ( VB, C++, FoxPro,
Excel, ... )
- Backspace and Delete work fine
As the problem only exists in Access and is dependent on the
Access version and binding to data, I was wondering if anyone
can think of any reason Access may interfere with the processing
of the Delete and/or Backspace key within an ActiveX object
on an Access form, and whether there is any simple solution
- maybe something obvious I am overlooking in Access.
Basically I just want to do all I can to help our customers and am
looking
for some solution.
If there is a better newsgroup for posting the question please do let
me know.
Jeff Bennett
Jeff @ btis DOT com