How adjust top and bottom margins within a single line edit control?
I have found that I can use SetMargins to adjust the margins to the left and
right of text within a (singleline) edit control. I would like to be able
to do the same thing with top and bottom margins but I can't find any nice
way of doing this. Does anyone know a good solution to this? The solutions
I have considered are:
(a) Use a multiline edit control and make it function as a single line edit
control (if that works). Then use SetRect or SetRectNP to reposition the
'formatting rectangle' (these only work with multiline edit controls).
(b) Use WM_NCCALCSIZE to ...Word field codes in Excel data file Includetext
Excel 2003 on XP
I want to use an Excel spreadsheet as a data file for a merge project that
is too large for a Word table, but I need to use Word field codes, expecially
Includetext, in the data. If I try to paste, or use paste special options,
with a field code created in a Word docment into Excel I get the resulting
text, not the code I want.
as a starting point:
"mranz" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:2D4F5F6F-6F4E-4DF2-B840-675AACE815B7@micros...In Word the shortcut keys to change from UC to LC is shift F3....
In Word the shortcut keys to change from UC to LC is shift F3, why not have
the shortcut keys to do the same in Excel?
is this a question on how to change case in Excel, or a request for MS to
implement the shift F3 short-cut, if it is the later then email them at
with excel in the subject line and details of what you would like in the
if the former then reposting in the form of a question might receive an
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"jdtrkohler" <jdtrkohl...Open a Word Doc referenced in a form field
I'm trying to set a button to open a word doc that is referenced in a
"DocName" field on my form. I've looked at several examples on this forum
but am unable to make it flow just right.
Are there any reference libraries I need to include? What is the most
efficient method to do this??
Thanx for your help
On Fri, 1 Feb 2008 09:12:00 -0800, Tom wrote:
> I'm trying to set a button to open a word doc that is referenced in a
> "DocName" field on my form. I've looked at several examples on this forum
> but am unable to make it flow just right.
...A spin on the old TRANSPOSE question
A "search" turns up dozens of repetitions of the same question: "How d
I convert a column of data into a row of data?" Easy: Copy, Past
Special, Transpose. But how about for a column of repeating data?
D and so on, to be converted to:
A B C D
A B C D
A B C D, continuing.
I recorded a quick macro to copy and paste special (transpose), but i
kept recopying the original copied data. Manually copying and pastin
is going to take way too long. Is there a formulaic method of doin
...cursor has changed from 10pt to 7pt
my document is Times Roman 10pt but my cursor is very tiny, probably 5 or 6pt.
How can i change it?
If this is Word 2003, you have encountered a known issue. Change the zoom
to, say, 500% and then back to whatever you want. That should fix the "mini
cursor" bug (at least temporarily).
Microsoft Word MVP
"Claudia" <Claudia@discussions.microsoft.com> wrote in message
> my document is Times Roman 10pt but my cursor is very tiny, probably 5 or
> How can i ch...DVD drive spinning up
How can I prevent the DVD drive pinning up each time when NOT in use?? In
configuration I have already disabled all auto run options!
Or is the only remedy taking out the disk each time?
| \/ |@rk
On 5/28/2010 10:17 AM, Linea Recta wrote:
> How can I prevent the DVD drive pinning up each time when NOT in use??
> In configuration I have already disabled all auto run options!
> Or is the only remedy taking out the disk each time?
Well it spins up even without a disc in the drive actually. It is just
quieter and it realizes pret...Haber and Thompson fonts come and go (Word 2004)
I have used the nonstandard Thompson and Haber fonts with past versions
of Word (5.1, 98...), (I had to add them into the font folder). They
now appear to be built in as "standard" fonts in Word 2004, but they do
not always appear in the font menu or font book in OS10.3. They seem
to come and go intermittantly. Sometimes a restart makes them
reappear, sometimes not. Any ideas what is going on here?
...Odd border around Edit Box
VC++ 6.00 (MS Developer Studio)
I created some simple edit boxes but wanted to change the background
color to white so I overrode OnCtlColor with this code:
if (pWnd->GetDlgCtrlID() == IDC_OUTPUT_STRIP)
// Set color to Black on White
pDC->SetBkColor(RGB(255, 255, 255));
which did have the desired coloring effect but has an odd artifact of
putting a black border around the edit box:
The first box was created with Class Wizard and has only the 'Border'
box checked. I've dink...Edit options in the forms tool bar un-usable
I have an employee here that is excel-savvy but can't
understand why she can't use the edit options in the forms
toolbar. (nor can I)These consist of the "Edit
Box", "Combination List-Edit", "Combination drop-down
edit", and "Edit Code" tools. Can anyone explain this to
me or tell me how to make them available? They're there,
they just aren't usable. I was thinking that she has to
be in a certain mode but I just don't know.
It's to be compatible with excel 5 files, with files created with 97 and
later they are not avai...Contact Edit
Windows 7, I bring up the Edit Contact window but can not change the
email address. How do I do That?
After you click Edit Contact, are you clicking Contact at the left?
Imperial Beach, CA
"Earl Partridge" <email@example.com> wrote in message
> Windows 7, I bring up the Edit Contact window but can not change the
> email address. How do I do That?
When you open the main "Edit Contact" window, you still have to sele...Count the words in a cell
A cell contains a lot of information.
Is it possible to count certan word in a cell please?
Say A1 contains a series of text ....
1. Daily Swing even though Sto is hit high or low
2. Look at Chart pattern
3. Stop at dangerous level
How can I count number of "O" in the cell A1 please?
Note that SUBSTITUTE is case sensitive.
Microsoft Excel MVP
"Elton Law" <EltonLaw@discussions.microsoft.com> wrote in message
news:43F...Comparing Two Documents
I was on the Word Newsgroup yesterday and posted a query
asking if I could compare two documents if I had the
original and the updated version, and to my amazement I
could (using Tools-> Tracked Changes)!!!!
I am therefore wondering if there was anything similar for
Excel?? I have two documents from an external source -
both of which follow the same layout and have the same
sheets in the same order etc. Is there any way of
detecting what changes have been made since the original
document was issued (i.e. to key inputs and also to
formulae within cells???)
I would rea...Printing vendor item number of primary vendor on SOP documents
Has anyone figured out a way to print the primary vendor's item # on a SOP
picking ticket, packing slip, order or invoice?
I'm looking at changing my part # scheme to eliminate having the Vendor part
# in our item numbers, but I need to still print that vendor # somewhere (or
I'll have a revolt from my service techs!).
Should just be a modification to add that field to whatever document
you want it on using Report Writer.
Frank Hamelly, MCP-GP
NOVA Solutions LLC
I realize that that's the solution, but my real question is how do I properly ...Cursor disappears 11-25-09
Today installed Office 2010 Beta. Am running Windows 7. While using Word from
this suite (which I understand is actually Word 2007), if I hold down the
spacebar the cursor disappears while it is advancing. I can't tell where it
is until I release the spacebar. Very troublesome and I can't find a way to
Word in Office 2010 is Word 2010, but its behaviour in this regard is the
same as it was in 2007, which was a change from earlier versions. The cursor
does not disappear, but it does not stop flashing and, so, is not always
If you must do ...About Cursor
I create two views using splitter window in MFC, while the left one is used
to set options and the right one draw the scene according to the command of
the left one with openGL.
Now I want the cursor of the mouse is visial in the left view and unvisial
in the right one.That means when the cursor falls in the rect of the right
view it disapeared and in other field it works all right! How can i do that?
Have any ideas?
Probably the simplest way is to have an OnSetCursor handler in the RH window and do a
SetCusor(NULL) to hide the cursor.
On Fri, 24 Jun 2005 09:44:27 +080...Why has Word 2007 suddenly become extremely slow?
I copied my user-defined templates from Word 2003 to the library where Word
2007 stores its templates and suddenly it slowed down, so that it takes 15-20
seconds for the program to open or for a file to load. Nothing like this has
happened to other Office programs. Word 2007 also started asking for a folder
to save "Normal.dotm" refusing to use its standard template folder.
For general troubleshooting, see
Microsoft Word MVP
"Frank Grevil" <Frank Grevil@discussions.micros...Create a Word Search Puzzle in Excel
I recently attended a Tips, Techniques and Shortcuts
course for Excel. The instructor showed an intriguing
feature...he created a Word Search Puzzle in seconds using
May anyone direct me on how to create this puzzle? My
children are constantly tasked to make these puzzles for
school . I think this would be really cool for them to
Briggitte, not for excel, but this site has a lot of puzzles you can make
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any r...Closing outlook
what can i do, when my outlook 2003 is slow in closing them?
Perhaps something is interfering with the closing of the file and holding
Outlook open. Often third party integration can cause this issue:
synch software for a handheld
To see if this is the case, open Outlook in safe mode:
Start > Run > outlook.exe /safe
(note the space between outlook.exe and /safe)
If it then closes without issue, you will have to check for third party Add
Ins that integrate with Outlook to see which one is causi...count number of characters in rich edit control
How can i count number of characters in rich edit control 2
If u mean controls of type Rich TextBox control, try
"Rahul" <Rahul@discussions.microsoft.com> wrote in message
> How can i count number of characters in rich edit control 2
EM_GETTEXTLENGTHEX, WM_GETTEXTLENGTH, WM_GETTEXT, EM_STREAM*
"Rahul" <Rahul@discussions.microsoft.com> wrote in message
> How can i co...bad type for word wrap
Dynamics GP v9.0
Message pops up in a window with the error "Bad type for word wrap."
User creates a credit memo, saves, posts. When printing this message pops
up. It does not cause any problems with the posting or printing. It is more
of an annoyance than anything. Can anyone tell me how to stop it from popping
up? It happens even if I change the default printer.
Has the posting report been modified? If so, does the same message appear if
you disable the modified report for the user, forcing use of the standard
I've entered the spinoff data for Medco Health solutions
from Merck and Money 2000 running under Windows 2000 ME
responds with "This operation cannot be performed" after
the last piece of data is entered. A microsoft human
suggested the data I'm entering must be bad.
Thanks for looking at this,
Anxious in Asheville
I always hate having to send people down this path, but I fear you are a
good candidate to read: http://www.bollar.org/msmoney/#Q104. Good luck.
<firstname.lastname@example.org> wrote in message
> I'...Using a macro to edit cells?
Is there a way to edit cells similiar to conditional formatting but us
a macro button to perform the desired action? This macro would d
something based on cell contents. I.e. bold all text that starts wit
a certain set of characters
bdunk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=50
View this thread: http://www.excelforum.com/showthread.php?threadid=26548
of course this is possible. Have you already experience with VBA?
"b...Document Library/Download/Login Popup
I have my SP server set up for internal access and external access using
active directory integration and also local user accounts on the SP server
itself. When accessing internally, IE uses the cached credentials when
access SP and the user does not have to enter user/pass. If i open a
document internally, it opens fine. If i access the server from external, i
always have to enter a user/password to access the SP at all. When i click
to open a document, it asks me again for the user/password before the
document will open. I do not want to choose the option of checking the box
...Renumbering a List in Word 2008
If I recall correctly (and there is a definite risk in that ;) ), back
in Word 5.1a I could select a group of numbered paragraphs that had not
been correctly ordered and invoke a Reorder command and it would do so.
I do not think those paragraphs were in a "list style."
Is there a similar feature in Word 2008?
And if so, does it work whether the paragraphs are in a list or
In the Palaeolithic versions of Word, numbers were not lists they were
"Text" and you could sort on them.
In modern versions of...