如何隐藏基于其他字段值的文本框为零 [英] how to hide a text box based on other field value is Zero

问题描述

亲爱的上师

我需要发出< g class =" gr_ gr_50 gr-alert gr_gramm gr_inline_cards gr_run_anim语法multiReplace"数据-GR-ID =" 50" id =" 50">凭证< / g>基于客户选择

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

我附加了< g class =" gr_ gr_100 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace"数据-GR-ID =" 100" id =" 100"> file，< / g>报告中显示

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

客户< g class =" gr_ gr_269 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace"数据-GR-ID =" 269" ID = QUOT; 269">采取< / g取代;国家< g class =" gr_ gr_271 gr-alert gr_gramm gr_inline_cards gr_run_anim
Style multiReplace"数据-GR-ID =" 271" id =" 271"> A，< / g>国家B或< g class =" gr_ gr_263 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace"数据-GR-ID =" 263" ID = QUOT; 263"> graudate< / g取代;
等..

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..

所以，< g class =" gr_ gr_319 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace"数据-GR-ID =" 319" ID = QUOT; 319" I标记< / g取代; a< g class =" gr_ gr_321 gr-alert gr_gramm gr_inline_cards gr_run_anim
Style multiReplace"数据-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"数据-GR-ID =" 320" ID = QUOT; 320" I标记< / g取代;
需要显示 如果他们选择了国家A 

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 

国家A  &NBSP; - " 1 QUOT;&NBSP; （这是文本< 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> 未绑定的框"< 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使用Can Shrink删除ünbound框但不删除< g class =" gr_ gr_523
gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id =" 523" id =" 523" ;>文本框< / g>

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>

如果值为"0"

我有附件 -   https://www.dropbox.com/s/h0c3r2xeq8nmb20/Database101.accdb?dl = 0

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

Eric

推荐答案

嗨Eric，

由于您的帖子内容已损坏，因此可以避免ding误解，我建议你更新你的帖子内容。

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

根据当前的帖子，如果值为0，你似乎想隐藏像国家A这样的字段。

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

我建议您为控件设置Can Shrink属性，然后自定义Report_OnFormat事件，如下所示。

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

最好的问候，

Terry

这篇关于如何隐藏基于其他字段值的文本框为零的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！