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

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

Answer 1

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 [e-mail].