Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2021, 12:06 PM
chrscote chrscote is offline How do I replace a field with regular text Windows 7 64bit How do I replace a field with regular text Office 2010 64bit
Novice
How do I replace a field with regular text
 
Join Date: Aug 2016
Posts: 12
chrscote is on a distinguished road
Exclamation How do I replace a field with regular text

I have a field in which I need to change to the last baseline entered in DOORS. I will be sending this data into a macro, but I don't want to keep the field when I change its text. Is it possible to replace the field with regular text so that the user doesn't see it as a field and if so, how do I do this?




Chris
Reply With Quote
  #2  
Old 06-29-2021, 01:35 PM
Charles Kenyon Charles Kenyon is offline How do I replace a field with regular text Windows 10 How do I replace a field with regular text Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Assuming your field is selected:
Selection.Fields(1).Unlink
Reply With Quote
  #3  
Old 06-29-2021, 08:16 PM
gmayor's Avatar
gmayor gmayor is offline How do I replace a field with regular text Windows 10 How do I replace a field with regular text Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

What kind of field?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #4  
Old 06-30-2021, 04:41 AM
chrscote chrscote is offline How do I replace a field with regular text Windows 7 64bit How do I replace a field with regular text Office 2010 64bit
Novice
How do I replace a field with regular text
 
Join Date: Aug 2016
Posts: 12
chrscote is on a distinguished road
Default

I have 2 fields actually. One is a date field and the other is a document variable. The date field is the first field and the document variable field, called previousBL, is the second one. It is very important that I change at least the date field to regular text so that it doesn't change each day when the user opens the document.


Chris
Reply With Quote
  #5  
Old 06-30-2021, 05:15 PM
Guessed's Avatar
Guessed Guessed is offline How do I replace a field with regular text Windows 10 How do I replace a field with regular text Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Date fields have useful variations which I would recommend before you throw the baby out with the bathwater. Perhaps you can use one of the other variations instead of unlinking the field.
{Date} is problematic as it shows today's date whenever it is updated
{CreateDate} is the date that the document was created (or the date you used SaveAs)
{SaveDate} is the date the document was last saved. This won't have a value until the doc has been saved at least once and the field is updated.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
field codes



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I replace a field with regular text Find and replace a text with a field eduzs Word VBA 6 02-23-2018 05:19 PM
How do I replace a field with regular text Macro to find text and replace with form field containing that text iiiiifffff Word VBA 16 06-04-2016 01:47 AM
Macro to find coloured text and replace with form-field/formtext containing that text tarktran Word VBA 1 11-26-2014 08:12 AM
search and replace a field containing text and numbers H28Sailor Word 6 09-11-2014 01:00 AM
Replace activex checkbox by regular one Darghon Word 0 11-15-2012 09:24 AM

Other Forums: Access Forums

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