Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2016, 03:39 PM
kirkm kirkm is offline Binding text to a Form control. Possible? Windows XP Binding text to a Form control. Possible? Office 2003
Advanced Beginner
Binding text to a Form control. Possible?
 
Join Date: Aug 2013
Posts: 40
kirkm is on a distinguished road
Default Binding text to a Form control. Possible?

Can you send text to a textbox on a Form, so that edits there will reflect back in the document?
My goal is to work through the doc checking OCR errors in first & last names and save corrections.

I'm storing each name to Excel once confirmed, then reading them back so I don't need to do the same name twice.
It's working fine, but a Form may be better than the debug window for output and avoid stopping/ restarting the macro. If the Form is modal I should be able to work through the whole document in one go.


But I'm stuck on a method for replacing a paragraph with the text box contents of a text box.

Thanks for any help
Reply With Quote
  #2  
Old 09-19-2016, 05:00 PM
macropod's Avatar
macropod macropod is offline Binding text to a Form control. Possible? Windows 7 64bit Binding text to a Form control. Possible? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you're using spell-check in conjunction with your process, there shouldn't be any need for any of that - simply tell the spell-checker to automatically fix all occurrences of the same error.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-19-2016, 05:21 PM
kirkm kirkm is offline Binding text to a Form control. Possible? Windows XP Binding text to a Form control. Possible? Office 2003
Advanced Beginner
Binding text to a Form control. Possible?
 
Join Date: Aug 2013
Posts: 40
kirkm is on a distinguished road
Default

Problem is spell checker only checks one word. I need first and last names together.
Reply With Quote
  #4  
Old 09-19-2016, 05:50 PM
macropod's Avatar
macropod macropod is offline Binding text to a Form control. Possible? Windows 7 64bit Binding text to a Form control. Possible? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

A simple way would be to use Find/Replace, by selecting the problem 'name' and replacing all such occurrences with the corrected one. No macros, storage, etc. required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 09-19-2016, 06:02 PM
kirkm kirkm is offline Binding text to a Form control. Possible? Windows XP Binding text to a Form control. Possible? Office 2003
Advanced Beginner
Binding text to a Form control. Possible?
 
Join Date: Aug 2013
Posts: 40
kirkm is on a distinguished road
Default

No. I'm correcting OCR errors and the 'problem name' may not be the same for all.
Reply With Quote
  #6  
Old 09-19-2016, 06:11 PM
macropod's Avatar
macropod macropod is offline Binding text to a Form control. Possible? Windows 7 64bit Binding text to a Form control. Possible? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It doesn't really matter whether the 'problem name' is the same for all - you fix them one at a time; there really is no more practical way. Having done OCR corrections numerous times, I'm aware the OCR process might mis-spell the same name a number of different ways; you simply need to handle each instance as it arises. The only thing saving any of the data might achieve is to provide you with a selection of replacement names to pick from. That's a fair coding effort for relatively little gain.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 09-19-2016, 06:42 PM
kirkm kirkm is offline Binding text to a Form control. Possible? Windows XP Binding text to a Form control. Possible? Office 2003
Advanced Beginner
Binding text to a Form control. Possible?
 
Join Date: Aug 2013
Posts: 40
kirkm is on a distinguished road
Default

Although, one gain would be to learn some new methods in Word VBA. I've also got a fair bit to do, so once finished it'll be used enough to warrant the effort. Yes, you're onto it...I have an ADO connection to Excel and store the names there (names + designation and the particular format used). I isolate each "name" correct if necessary, and add to Excel if not already there. Allows a match of each new instance, replacing only those needing it. Becoming less as I move through the doc. LOL It works for me! (But I'd never used Word VBA until now, so that's the nightmare part). Thought I'd lost a whole days work because didn't know to enable macros....
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Properties for data entry control on Form help EricMannzi Word VBA 10 02-24-2015 09:48 AM
form control Field - Drop down auto text mrtinfl Word 5 11-19-2014 06:57 AM
Binding text to a Form control. Possible? Allow Multiple Content Control same cell of form table DeborahBartlett Word 1 01-04-2014 11:06 AM
Binding text to a Form control. Possible? MS WORD 2007 - Content Control versus Text Form Field question chamdan Word VBA 2 11-12-2013 09:51 PM
Binding text to a Form control. Possible? Word 2003 - IncludeText Does Not Include Bookmark Text if in a Form Text Control skarden Word 1 12-12-2011 10:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft