X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Trying To Edit Number Of Undo Items In Stack Access 2007, Access 2007    
post Mar 5 2019, 07:11 PM

Posts: 38
Joined: 17-July 10
From: Ventura, CA

Hello all -

I've been trying to edit the number of undo events saved in an Access record and I can't find a thing. It's very interesting that I can Google the question and come up with fixes for Excel and PowerPoint, but I can't find a peep about Access and those fixes don't seem to relate.

Does anyone know how to control how many undo steps are saved?

I always appreciate the efforts of people here.
Go to the top of the page
post Mar 29 2019, 07:00 AM

UtterAccess VIP
Posts: 1,565
Joined: 19-December 02
From: Lansing, MI

If you're wanting to limit the number of times a user can undo their typing, you can try setting the Cancel argument of the form's Form_Undo event under certain conditions, such as in response to your own counter variable.

If you need to control the undo levels in design view, have a look at these two hidden methods of the Application object:


I've used BeginUndoable a bit when building add-ins for developers. Normally if you use a custom designer to set form properties in design view with VBA, Access doesn't count that as an undoable design action. You have to force it to by calling Application.BeginUndoable before setting the properties with VBA. If you investigate this route, also note that this will only work if you set the WizHook key first.

I haven't used SetUndoRecording before, so no tips there. Just something to investigate. As always, take care with hidden methods and WizHook manipulation. No guarantees they will be supported in the future, etc.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    18th July 2019 - 01:49 AM