Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Tags
bible, indexing, marking syntax



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 09:09 PM.


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