如何指示字段是必需的 [英] How to indicate a field is required

问题描述

我有 连续 子表单，列出表格中的字段。我想说明该字段是否必需。


所以我需要在子窗体上进行可视化指示，而不是实际尝试输入数据。这是一个模拟

I have a continuous subform, listing the fields in a table. I want to indicate whether the field is required or not.

So I need a visual indication on the subform itself without actually trying to enter data. Here is a mock-up

附加图像

< tr>

RequiredField.png （13.1 KB，236 views）

Attached Images

RequiredField.png (13.1 KB, 236 views)

推荐答案

Hmmmmmmmm .....

我只是在想自己，自我（我总是称自己，''自我''），这真的很简单！


但是，我想，Phil希望根据表中 Field 的属性来改变 Control 的属性> - 对于表中的每个记录。


我认为这就是 Field 属性在控件级别不可用。如果它是一个单一的表格，你可以用VBA来做，但是这对连续表格来说并不是那么好用。


让我稍微咀嚼这个... ..

Hmmmmmmmm.....

I was just thinking to myself, "Self (I always call myself, ''Self''), this oughta be really simple!"

But, then I got to thinking, Phil wants to change a property of a Control based upon a property of a Field in a Table--for each Record in that Table.

I think the rub is that Field properties are not available at the Control level. If it was a Single Form, you could do it with VBA, but that doesn''t work so nicely with Continuous Forms.

Let me chew on this one a bit longer....

那么，如何确定是否需要字段？这可能是一个更好的起点。如果我正在考虑表级别，如果需要一个字段，则该表中的字段 - 但我知道这不是什么你在问。

By the way, how do you determine if a field is required or not? That might be a better starting place. If I am thinking Table level, if a field is required, the field is required in the table--but I know that is not what you are asking.

啊，Twinnyfo，如果它很简单，我希望我不会问。我只是想保持小灰细胞的工作。


不，我不想改变控件的任何属性，只是格式。

是的，字段在表格设计中与允许零长度一起确定。 &安培; "索引"等等


我试过

Ah, Twinnyfo, if it was simple, I hope I wouldn''t be asking. I am just trying to keep the little grey cells working.

No I don''t want to change any properties of the control, just the format.

Yes, the Field is determined in the table design along with "Allow Zero length" & "Indexed" etc.

I have tried

展开 | 选择 | Wrap | 行号

这篇关于如何指示字段是必需的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！