Modify feilds

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WAYNEL - 27 Sep 2006 12:13 GMT

How can I mondify the FileName feild so that it just gives me the
filename without the extention, with sa Left(FileName,8).

WayneL

Reply to this Message

Robert M. Franz (RMF) - 27 Sep 2006 12:33 GMT

Hi Waynel

> How can I mondify the FileName feild so that it just gives me the
> filename without the extention, with sa Left(FileName,8).

In short: you don't.

You can change the way Windows itself displays filenames (w/o the
extension), but this is generally not a good idea.

But there's no field switch doing what you ask for (and God knows we've
asked for such things repeatedly :-)).

You could programmatically (on saving?) insert the filename into a
Document variable or property and reference this instead.

HTH
Robert

Signature

/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word

Reply to this Message

WAYNEL - 27 Sep 2006 12:44 GMT

Hi Robert

Is there someway of using VBA say NoExt = FileName, then say insert
that into a feild?

WayneL

> Hi Waynel
>
[quoted text clipped - 19 lines]
> X Against HTML | for
> / \ in e-mail & news | Word

Reply to this Message

Robert M. Franz (RMF) - 27 Sep 2006 13:18 GMT

> Is there someway of using VBA say NoExt = FileName, then say insert
> that into a feild?

You can do almost anything in VBA, like define your own macro which
inserts the filename to your liking at the insertion point. But I don't
know of anything you can do to actually change the output of a FILENAME
field in the way you want it.

[BTW, even if you _had_ the possibility to use simple string
manipulation on the field itself, not every document name consists of
8+3 ...]

Greetinx
Robert

Signature

/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word

Reply to this Message