Formatting Enterprise Text Fields

[Radha]

Hi,

I have created a custom Enterprise Text field using Project. I want to
ensure that any data entered in this field is of a particular format
(Specifically, 4 digits a hyphen 4 digits hypen 2 characters). Is there
anyway we could use a regular expression validator for the custom text field?

Thanks in advance.

Radha Mukkai

 

[Earl Lewis]

Radha,

Custom Enterprise Outline codes allow you to set this kind of formatting but they only allow users to select predefined values - not enter them with the keyboard. So if you were able to have a predefined list this could help. Otherwise, I think you're out of luck if you want to use the built-in project pro user interface elements.

An alternative would be to create your own custom form and write the validation routine for that form. This is pretty straightforward from the developers point of view - but you need to find a way to get users to the custom form.

I don't think there's any support for regular expressions built into VBA, but you can still code the validation with VBA w/o regex.

Hope that helps.

Earl
Hi,

I have created a custom Enterprise Text field using Project. I want to
ensure that any data entered in this field is of a particular format
(Specifically, 4 digits a hyphen 4 digits hypen 2 characters). Is there
anyway we could use a regular expression validator for the custom text field?

Thanks in advance.

Radha Mukkai

 

[Radha]

Thanks, Earl. We have a custom form for users to enter values which will be
stored in the custom enterprise text fields.

However, we do not want users to use the Project Information sub-menu under
the Project tab to enter information in the Enterprise text field. Is it
possible to disable the Project Information sub-menu item (I don't think it
may be possible. But if it is possible, that would be good).

Thanks once again.

Radha

 

[Earl Lewis]

Radha,

You can do just about anything you want with software. Often that's exactly the problem.

Anyway, there is a whole segment of the Office API that deals with menus and toolbars. You could write a routine that recreates this menu any way you like. It's a bit of a specialty area - and one that I'm not expert at by any means. I've fumbled through a few hacks but that's about it - so I can't give you any code right off the top of my head.

If you're really intent on doing this you should be able to find plenty of info in the office developers NG (microsoft.public.office.developer.vba).

Earl
Thanks, Earl. We have a custom form for users to enter values which will be
stored in the custom enterprise text fields.

However, we do not want users to use the Project Information sub-menu under
the Project tab to enter information in the Enterprise text field. Is it
possible to disable the Project Information sub-menu item (I don't think it
may be possible. But if it is possible, that would be good).

Thanks once again.

Radha

 

[Radha]

Thanks for your help, Earl.

Radha

Radha,

You can do just about anything you want with software. Often that's exactly the problem.

Anyway, there is a whole segment of the Office API that deals with menus and toolbars. You could write a routine that recreates this menu any way you like. It's a bit of a specialty area - and one that I'm not expert at by any means. I've fumbled through a few hacks but that's about it - so I can't give you any code right off the top of my head.

If you're really intent on doing this you should be able to find plenty of info in the office developers NG (microsoft.public.office.developer.vba).

Earl

Thanks, Earl. We have a custom form for users to enter values which will be
stored in the custom enterprise text fields.

However, we do not want users to use the Project Information sub-menu under
the Project tab to enter information in the Enterprise text field. Is it
possible to disable the Project Information sub-menu item (I don't think it
may be possible. But if it is possible, that would be good).

Thanks once again.

Radha