Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2021, 05:57 AM
VBAFiddler VBAFiddler is offline Using the dreaded colon in marking a field Windows 10 Using the dreaded colon in marking a field Office 2016
Novice
Using the dreaded colon in marking a field
 
Join Date: Feb 2021
Posts: 14
VBAFiddler is on a distinguished road
Question Using the dreaded colon in marking a field

Hi,
Thanks to these forums, I've successfully marked all my bible references preparatory to indexing. However, my index has gone a bit haywire. It's best explained by looking at the field associated with a bible reference.
Code:
"MATTHEW:7:28;01007028028


What the customer wanted was: a heading for each book in the index. No problem, we've MATTHEW followed by a colon. Then he wanted the reference, i.e. 7:28. The problem is that it is being interpretted as a second heading, so I get a heading for each book, and a heading for each chapter. The part after the semicolon defines my sort sequence.
Is there some way similar to the way backslashes are dealt with so that the colon is actually written as a colon rather than being interpretted as a subheading in the index. If not, I guess I'll need to convert the colon in the reference to a period.
Many thanks for any thoughts,
David.
Reply With Quote
  #2  
Old 02-10-2021, 11:50 AM
gmaxey gmaxey is offline Using the dreaded colon in marking a field Windows 10 Using the dreaded colon in marking a field Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,421
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Without seeing whatever code you are using, I haven't a clue what you are talking about.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 02-10-2021, 02:25 PM
macropod's Avatar
macropod macropod is offline Using the dreaded colon in marking a field Windows 10 Using the dreaded colon in marking a field Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

I already pointed you to a working solution in your other thread (https://www.msofficeforums.com/word-...confusion.html). Much easier than reinventing the wheel...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
bible, indexing, marking syntax

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the dreaded colon in marking a field How remove colon ':' from my chapter references? peytontodd Word 7 10-25-2023 07:13 PM
Auto Capitalization After Colon lowens Word 1 04-28-2018 02:58 PM
Using the dreaded colon in marking a field The difference between a comma and colon when adding? Exhale Excel 8 03-23-2016 05:26 AM
aligning colon JRaul Word 4 07-07-2012 06:06 AM
Two Spaces After Colon in Word 2010 alpinegroove Word 2 03-01-2012 08:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:30 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