Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-13-2012, 02:22 PM
ztag ztag is offline Prevent Field Calculation with Dates from introducing line break? Windows 7 32bit Prevent Field Calculation with Dates from introducing line break? Office 2003
Novice
Prevent Field Calculation with Dates from introducing line break?
 
Join Date: Jan 2012
Posts: 7
ztag is on a distinguished road
Default Prevent Field Calculation with Dates from introducing line break?

I have an implementation of Fields and Bookmarks that takes a date, adds some number of days to the date, and displays the new dates. I am taking the days and displaying them mixed in with some language text. I am also taking the resulting dates and attempting to display them with some language text, but the date calculations introduce a line break that I cant seem to get around.

Viewing the attached file will probably be helpful.

In the file, the revsubstcomplx fields are the are the new contract end dates (the calculated value), and the scopedaychangedayX fields are the number of days that are being added to the original date.

The "phenomenon" can be viewed on the third page - wherein the 1st field results display correctly because they only refer to number of days, the second the same, and the third results demonstrate the problem - where a line break has been introduced by the date reference.



Does anyone know how to prevent this date calculation from introducing a line break?

Thank you in advance, Macropod
Attached Files
File Type: doc Field Change Order Form - FULL - For Forum.doc (406.0 KB, 11 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent Field Calculation with Dates from introducing line break? Prevent Outlook from adding line breaks vektor Outlook 4 02-14-2012 02:16 PM
Prevent Field Calculation with Dates from introducing line break? Calculation within Cells manich1 Excel 2 12-07-2011 02:59 PM
Prevent Field Calculation with Dates from introducing line break? Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM
Prevent Field Calculation with Dates from introducing line break? Mail merge line break camlad Mail Merge 3 06-29-2011 05:01 PM
paragaph hard break, soft break and ...strange break czomberzdaniela Word 2 12-03-2010 06:58 PM

Other Forums: Access Forums

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