必填文本框条目 [英] required textbox entry

问题描述

我有一个列出了不同类型商家的组合框。如果用户

选择其他从我想要的组合框列表，以便用户

需要在表单上的文本框中输入。还有一个

的方法，只需要在表单必填字段上制作某些文本框，如果

，则会跳过它们以显示类似 HoursOfOperation是一个

必填字段将用户移动到每个必填字段进行输入？谢谢。

解决方案

2006年4月12日06:51:57 -0700， fo ******* @ martecgroup.com 写道：


这种类型的验证最好在Form_BeforeUpdate

事件：

if cbo1.Value =" Other"和txt2.Value Null然后

Msgbox"哟！填写表格！

txt2.SetFocus

取消=真''重要;这会阻止记录被保存。

结束如果


-Tom。

I有一个组合框，列出了不同类型的业务。如果用户选择其他或其他。从我想要的组合框列表，以便用户
需要在表单上的文本框中输入。还有一种方法可以在表单所需的字段上创建某些文本框，如果
它们被跳过以显示消息，例如 HoursOfOperation是一个
必填字段将用户移动到每个必填字段进行输入？谢谢。

我有以下时间记录对记录所做的更改


私人Sub Form_BeforeUpdate（取消为整数）

我！UpdatedOn =现在（）

结束子


我可以有时间戳吗以及在更新前的

表格中的上述验证？


谢谢。

我有以下时间记录对记录所做的更改


Private Sub Form_BeforeUpdate（取消为整数）

我！ UpdatedOn =现在（）

结束子


我可以在

中获得时间戳以及上述验证更新活动之前的表格？


谢谢。

I have a combo box with different types of business listed. If a user
selects "Other" from the combo box list I want to make so that the user
is required to make an entry in a textbox on the form. Also is there a
way to make just certain textboxes on the form required fields and if
they are skipped to display a message like " HoursOfOperation is a
required field" move the user to each required field for input? Thanks.

解决方案

On 12 Apr 2006 06:51:57 -0700, fo*******@martecgroup.com wrote:

This type of validation can best be done in the Form_BeforeUpdate
event:
if cbo1.Value = "Other" and txt2.Value Is Null then
Msgbox "Yo! Fill out the form!"
txt2.SetFocus
Cancel = True ''Important; this stops the record from being saved.
end if

-Tom.

I have a combo box with different types of business listed. If a user
selects "Other" from the combo box list I want to make so that the user
is required to make an entry in a textbox on the form. Also is there a
way to make just certain textboxes on the form required fields and if
they are skipped to display a message like " HoursOfOperation is a
required field" move the user to each required field for input? Thanks.

I have the following to time stamp changes made to the record

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!UpdatedOn = Now()
End Sub

Can I have the time stamp as well as the above validation both in the
form''s before update event?

Thanks.

I have the following to time stamp changes made to the record

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me!UpdatedOn = Now()
End Sub

Can I have the time stamp as well as the above validation both in the
form''s before update event?

Thanks.

这篇关于必填文本框条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！