web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Form Control Setup

(0) ShareShare
ReportReport
Posted on by

Hi, Is there any ways to hide one of the column from others 'company' that in a same database? It only show the particular column for selected 'Company', others than that, it won't display the column when open the form. Attached image is I want to show 'exchange rate' column for few of the 'company'. Thank You and have a good day.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Binesh Profile Picture
    7,885 on at
    RE: Form Control Setup

    Hello,

    You can do, see the below sample code

    //Demo Company' is your another company that you don't want to show
    Form - OnOpenForm()
    IF COMPANYNAME <> 'Demo Company' THEN

        CurrForm.Description.VISIBLE(FALSE)
    ELSE
       CurrForm.Description.VISIBLE(TRUE);

    Also write Form - OnAfterGetRecord()

    Note: Better to write a local function and that function

    write code for hidden the columns that you want to hide.

  • Community Member Profile Picture
    on at
    RE: Form Control Setup

    8473.7455.Capture3.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans