(Solved) – How to hide controls without record in Json string

  • by
(solved)-–-how-to-hide-controls-without-record-in-json-string

I need some help on how to make sure that some controls in Json string should not appear on the string if the Ms Access record source is showing blank/Empty record see below:

[
   {
      "ItemNumber": 1,
      "SalesDate": "2019-09-14",
      "ProductName": "Pepsi (Rgb 350 ML)",
      "BarCode": "6009803227328",
      "Qty": 165,
      "Price": 53.5,
      "VAT": Null
      "TotalPrice": 10239.9
   },

Let us assume VAT control in MS Access record source is empty/blank, then the string should look like below:

[
   {
      "ItemNumber": 1,
      "SalesDate": "2019-09-14",
      "ProductName": "Pepsi (Rgb 350 ML)",
      "BarCode": "6009803227328",
      "Qty": 165,
      "Price": 53.5,
      "TotalPrice": 10239.9
   },

Kindly see if it is possible to sort out this.

Leave a Reply

Your email address will not be published. Required fields are marked *