You are here:

VB Script/Access data page customization during run time

Advertisement


Question
I have a access data page that shows customer data. Now it hasa field 'Shipping status' and 'Shipping date'. Now what I want is if Shipping status is "shipped" then make "Shipping Date" field invisible.

How can I do this?
Thanks a lot.

Answer
I haven't worked with Access data pages, but from a Visual Basic perspective this is a good place to use event code.  
In this case, I would add code to the event equivalent of a "data page browse" and "Shipping status value change" (sorry, I don't know the exact names of these events) checking the value of the Shipping status field and setting the property "Visible" of the Shipping Date field.

Sorry if this is too vague, but I have no experience with the tool you are using.
Miguel.

VB Script

All Answers


Answers by Expert:


Ask Experts

Volunteer


Miguel Zapico

Expertise

I can answer question about how to use scripts to consolidate data, connect different systems and automate tasks. I have no experience on using VBScript on web programming.

Experience

I have been using VBScript and Windows Scripting Host as my swiss tool for the last 6 years.

Organizations
New York PC users group (NYPC)
Independant Computer Consultants Association (ICCA)

Education/Credentials
Microsoft MCSE in Windows NT

©2012 About.com, a part of The New York Times Company. All rights reserved.