none
how to hide a text box based on other field value is Zero RRS feed

  • Question

  • Dear Guru

    I need to issue <g class="gr_ gr_50 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="50" id="50">an voucher</g> that based on client choices

    I have attached the <g class="gr_ gr_100 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="100" id="100">file ,</g> shown in the Report

    Client <g class="gr_ gr_269 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="269" id="269">taken</g> Country <g class="gr_ gr_271 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="271" id="271">A ,</g> Country B or <g class="gr_ gr_263 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="263" id="263">graudate</g> etc..

    So, <g class="gr_ gr_319 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="319" id="319">i</g> a <g class="gr_ gr_321 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="321" id="321">report ,</g> <g class="gr_ gr_320 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="320" id="320">i</g> need to show  if they selected Country A 

    Country A   -"1"  ( this is the text <g class="gr_ gr_412 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="412" id="412">box ,</g> Unbound box" <g class="gr_ gr_439 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="439" id="439">i</g> can use Can Shrink to remove the ünbound box but not the <g class="gr_ gr_523 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="523" id="523">Text Box</g>

    if the value is "0"

    I have attached file - https://www.dropbox.com/s/h0c3r2xeq8nmb20/Database101.accdb?dl=0

    Eric

    Tuesday, October 17, 2017 2:09 PM

All replies

  • Hi Eric,

    Since your post content is corrupt, for avoiding misunderstanding, I would suggest you update your post content.

    According to current post, it seems that you want to hide field like Country A if is value is 0.

    I would suggest you set Can Shrink property for the control and then custom Report_OnFormat event like below.

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    
    If CountryA.Value = "0" Then
    
    CountryA.Visible = False
    
    CountryA_Label.Visible = False
    
    Else
    
    CountryA.Visible = True
    
    CountryA_Label.Visible = True
    
    End If
    
    End Sub


    Best Regards,

    Terry


    MSDN Community Support Please remember to click &quot;Mark as Answer&quot; the responses that resolved your issue, and to click &quot;Unmark as Answer&quot; if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, October 18, 2017 9:48 AM