Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-11-2013, 08:41 AM
dbsoccer dbsoccer is offline Position of text inside of task bar Windows XP Position of text inside of task bar Office 2007
Novice
Position of text inside of task bar
 
Join Date: Apr 2012
Posts: 21
dbsoccer is on a distinguished road
Default Position of text inside of task bar

When I add text 'inside' the task bar, it is left justified. Can it be center justified? Project Professional 2010.
Reply With Quote
  #2  
Old 10-12-2013, 08:47 AM
JulieS JulieS is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

No, not to the best of my knowledge.
Reply With Quote
  #3  
Old 10-12-2013, 01:54 PM
renke.holert renke.holert is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 32bit
Novice
 
Join Date: Oct 2012
Posts: 1
renke.holert is on a distinguished road
Default Use custom field to center task name

Hi,

as Julie said it's not possible in standard, but you can workaround using a custom field as I just posted here for you:

http://community.allocatus.com/blogs...arstellen.aspx

Best,
Renke
Reply With Quote
  #4  
Old 10-14-2013, 05:30 AM
JulieS JulieS is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Thank you Renke!
Reply With Quote
  #5  
Old 10-24-2013, 01:20 PM
dbsoccer dbsoccer is offline Position of text inside of task bar Windows XP Position of text inside of task bar Office 2007
Novice
Position of text inside of task bar
 
Join Date: Apr 2012
Posts: 21
dbsoccer is on a distinguished road
Default

This appears to be a great solution. My German is not good so I can't read what is on the link.

I muddled my way around and discovered how to add a custom field and am trying to understand what to do based on the pictures and not the German. I have copiedthe formula and am getting a syntax error, the semi-colon just before the first [Start]. If I change the semi colon to a comma, the syntax error moves to the next semi-colon.

IIf(2,6*DateDiff("d";[Start];[Finish])+1-(len([Name]))>0;space(2,6*DateDiff("d";[Start];[Finish])+1-(len([Name]))) & [Name];[Name])

Any thoughts on what I am doing wrong?
Thanks.
Reply With Quote
  #6  
Old 10-24-2013, 02:25 PM
JulieS JulieS is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Try replacing the ; with a comma.
Reply With Quote
  #7  
Old 10-25-2013, 08:10 AM
dbsoccer dbsoccer is offline Position of text inside of task bar Windows XP Position of text inside of task bar Office 2007
Novice
Position of text inside of task bar
 
Join Date: Apr 2012
Posts: 21
dbsoccer is on a distinguished road
Default

Thanks Julie. The compiler now stopped at the ampersand (&). I tried replacing this with AND and it still didn't like it.

Any other ideas?
Reply With Quote
  #8  
Old 10-25-2013, 09:36 AM
JulieS JulieS is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi,

I'm getting regular errors as well, but haven't had time yet to try to sort it out. I'll let you know when I have a chance to crack it.
Reply With Quote
  #9  
Old 10-25-2013, 10:21 AM
JulieS JulieS is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I am getting closer with:
IIf(DateDiff("d",[Start],[Finish])+1-len([Name])>0,Space(3*DateDiff("d",[Start],[Finish])+1-len([Name])) & [Name],[Name])
Reply With Quote
  #10  
Old 10-31-2013, 01:21 PM
dbsoccer dbsoccer is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 64bit
Novice
Position of text inside of task bar
 
Join Date: Apr 2012
Posts: 21
dbsoccer is on a distinguished road
Default

I am beginning to understand this code a bit better. The issue I see is the 3x multiplier is dependent on the timescale you're using. SPACE returns a number that is used to create a blank section prior to writing the NAME. The blank space is a number of spaces as returned by the SPACE function. But the length of the space is probably not the same length as a 'day' represents on the gantt chart again depending on the time scale being used. In my case, where my time scale is very compressed I had to actually divide the number of spaces returned to get the text to fit on the bar.

I would hope there is a way to account for the time scale.
Reply With Quote
  #11  
Old 11-01-2013, 06:20 AM
JulieS JulieS is offline Position of text inside of task bar Windows 7 64bit Position of text inside of task bar Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Custom formulas cannot react to user settings such as zooming in or out of the timescale. The only method I can imagine is to set the indentation within the task bar through VBA code - and I am not the person to help out with that, sorry.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Position of text inside of task bar Locking Text Box Position - Word Mac 2011 citizenzen Word 3 02-01-2013 12:24 PM
Position of text inside of task bar How do I place a text box inside of a picture and still have background show through jyfuller Word 1 06-09-2012 09:51 AM
Macro for absolute text box re-position hobbsbaboo PowerPoint 0 03-15-2012 01:44 AM
Position of text inside of task bar The printed pdf file doesn't print an equation inside text box! why? Jamal NUMAN Word 4 07-01-2011 06:27 PM
Shortcut inside Word 2010 or 2007 to format text Ross Word 0 03-03-2010 05:54 PM

Other Forums: Access Forums

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